Set analysis query

[rakesh_kumar]

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,

RK

[#2]

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!

[alexandros17]

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

[rakesh_kumar]

Thanks for the reply.

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

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

[alexandros17 · Accepted solution]

Let's suppose you select June

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

[ Sum(Amount) ]  consider it

[rakesh_kumar]

Thank you thats helpful !

[buzzy996]

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