topic Re: Set analysis query in QlikView

Set analysis query

rakesh_kumar — Wed, 03 Jun 2015 14:57:23 GMT

Hi Guys,

Sorry if this has already been anwsered else where in the community, I have seen some expressions like this Sum({<Month= >} Amount) ,

my query is why here <Month = > left as blank in the set analysis, whats its purpose?

Also if you can provide any references to any documents or posts in Qlik community that explains this concept, thats even more appreciated?

Thanks,

Re: Set analysis query

Wed, 03 Jun 2015 14:59:09 GMT

Hi,

I found that using Set Analysis Wizard for QlikView | qlikblog.at helped me most in understanding Set Analysis, but also found it most convenient way to create these expressions. It also provides an explanation of what every expression does when you create one, which is really useful for maintenance on your document.

Hope this helps a bit!

Re: Set analysis query

alexandros17 — Wed, 03 Jun 2015 15:03:14 GMT

The sum is done whatever value month field has (so sum do not consider any particuklar value for Month)

Re: Set analysis query

rakesh_kumar — Wed, 03 Jun 2015 15:09:55 GMT

Thanks for the reply.

In that case, is [ Sum({<Month = >} Amount) ] = [ Sum(Amount) ] ??

Then why to use {<Month = >} ??

Re: Set analysis query

alexandros17 — Wed, 03 Jun 2015 15:17:09 GMT

Let's suppose you select June

[ Sum({<Month = >} Amount) ] doesn't consider the selection

[ Sum(Amount) ] consider it

Re: Set analysis query

rakesh_kumar — Wed, 03 Jun 2015 15:36:44 GMT

Thank you thats helpful !

Re: Set analysis query

buzzy996 — Wed, 03 Jun 2015 16:12:38 GMT

for excluding the selection of corresponding field this case month,we will such kind of syntax.