The indicators can be viewed for previous months and not just the current month.Lost customers are those that have purchased historically within the last 120 days, but have not purchased anything within the previous 60 days.New customers are those that purchased for the first time ever anything within the previous 30 days.Our example business rules are the following: One real world application of nested Set Analysis helps us define the business rules that define the indicators for won and lost customers, which are key indicators in any sales application.
Will filter the customers that have sales greater than ten thousand for products containing garlic.
Nested Set Analysis is when we use an advanced search to filter a field that itself is also filtered by Set Analysis. The only acceptable exception to this rule would be when we use nested Set Analysis. The easiest solution is to always use either one or the other. Subsequently, when we train others who don’t have a technical background to write Set Analysis, it is important to remain consistent and keep the expressions as simple as possible. For example, will give you the same result as , and contrary to what Qlik Help states, returns the same result as. It is made even more confusing by the fact that in practice there doesn’t appear to be any difference between using the double quote ( ” ) and the single quote ( ‘ ). However clear this may be to some, it can be perplexing to others. On the other hand, a single quote ( ‘ ) denotes a string value. For example, 10000”}> will select all customers that have a sum of sales greater than ten thousand and =2008 will select all including between and including 20. Will select all ingredients including the string ’garlic’.Ī search can also be based on a formula or a range. According to Qlik Help (a great resource), A search is always defined by the use of double quotes, e.g.
One of the confusing attributes of Set Analysis syntax is knowing when to use double quotes ( ” ) and when to use single quotes ( ‘ ). Additionally, I will use examples of commonly used indicators that you can re-use for your own Qlik applications. I believe that one day applying simple and complex business rules will be made easier, but until then, I’m going to share tips and tricks to keep Set Analysis syntax as simple as possible. Those same business users that use Excel today for their analytical needs and aren’t completely convinced that Qlik is accessible enough to perform their own custom analysis. I love the analysis that can be done using Qlik’s Set Analysis, but its syntax leaves too many business users lost and confused.
0 kommentar(er)
