topic Re: Only & Set Analysis & Total syntax in QlikView

Only & Set Analysis & Total syntax

Sun, 28 Feb 2016 03:07:50 GMT

Hi all, help understanding the following syntax. I understand usually syntax for set analysis is

sum({$<FIELD={'VALUE'}>}Amount)

I don't understand following concept. Why angle brackets come after set analysis syntax instead of original set analysis concept?

=ONLY({1}TOTAL <Month>Amount)

Thanks!

Re: Only & Set Analysis & Total syntax

johnw — Mon, 29 Feb 2016 18:35:30 GMT

The only set analysis here is {1}, which is saying to take the entire data set ignoring all selections. The rest is unrelated to set analysis, just additional modifiers to your only() aggregation. TOTAL says to ignore all chart dimensions and perform the only() aggregation disregarding the chart dimensions. So {1} TOTAL is saying "give me everything, and I mean everything, ignore selections, ignore chart dimensions". But <Month> modifies that further, adding, "well, except for the Month dimension, I DO care about that, do this for only the Month for this row in the chart".

So for a given row in your chart, if there is only a single Amount in your entire data set for the month associated with that row, then you will see that Amount, else you will get null.

Re: Only & Set Analysis & Total syntax

Mon, 29 Feb 2016 19:02:53 GMT

Thanks for clearing this up; it's all too clear now