topic Re: Set analysis in QlikView

Set analysis

geogou1973 — Thu, 07 Jan 2016 21:15:09 GMT

Hello.

I have the following formula. How can i rewrite this without the data change from current selection that the user is doing ?

Sum({<SALES_YEAR={'$(=MAX(SALES_YEAR))'},SALES_MONTH={'$(=VMONTH)'},FORMAT={'FRANC'},SALES_DATE=>}AMOUNT)

Thank you in advance.

Anonymous — Thu, 07 Jan 2016 21:27:30 GMT

I'm a bit confused, are you saying you want to ignore the user selections?

If that's the case, put a 1 in the beginning of the set analysis

Sum({1<SALES_YEAR={'$(=MAX(SALES_YEAR))'},SALES_MONTH={'$(=VMONTH)'},FORMAT={'FRANC'},SALES_DATE=>}AMOUNT)

geogou1973 — Thu, 07 Jan 2016 21:33:45 GMT

Hello David.

I have already put this in the formula but i have the same results. It takes also the selections of the users

sunny_talwar — Thu, 07 Jan 2016 21:44:33 GMT

Try this:

Sum({1<SALES_YEAR={'$(=MAX({1}SALES_YEAR))'},SALES_MONTH={'$(=VMONTH)'},FORMAT={'FRANC'},SALES_DATE=>}AMOUNT)

Might need {1} within VMONTH variable also.

MK_QSL — Thu, 07 Jan 2016 23:08:23 GMT

And might for VMONTH also..