topic Re: set analysis basic question in QlikView

set analysis basic question

surajap123 — Wed, 09 Oct 2013 10:56:34 GMT

HI Experts,

I have a doubt on the importance of $ symbol in set analysis

sum({$ <Year={2007,2008}>} Sales) --->returns the sales for the current selection

I dont understand the statement. Does it mean the above expression returns sales amount when user clicks on 2007 or 2008 year?

I always have this doubt with $ symbol in set analysis. I dont understand what current selection has to do in the expression.

Could anyone give me explaination with examples.

Thanks a lot !!

Regards,

Suraj

Re: set analysis basic question

Gysbert_Wassenaar — Wed, 09 Oct 2013 11:01:25 GMT

It means it will return the sales of both 2007 and 2008 no matter what year the user selects. The $ means that for the other fields the selections of the user are applied. Only the Year field is overruled by the set modifier Year={2007,2008}.

Re: set analysis basic question

swuehl — Wed, 09 Oct 2013 11:02:15 GMT

This statement changes the selection in Year to 2007 and 2008 selected, while keeping all other compatible selections, like selections you may have made in Country or Customer.

If the user selects something different in Year field, his selection will be overwritten with 2007 and 2008 for this aggregation.