topic set analysis basic in QlikView

set analysis basic

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,
I am new to qlikview , still learning set analysis

please explain in this expression

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(QuarterStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)}

what this means

Year=, Month=, Quarter=, Week=, DateField=,

especially equal to sign

Re: set analysis basic

sunny_talwar — Mon, 29 Jan 2018 19:53:31 GMT

This just means that ignore any selection made directly in those fields which are listed within set analysis... you can write this without the equal sign also and it would still mean the same thing

Sum({<Year, Month, Quarter, Week, DateField, DateNum={">=$(=Num(QuarterStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)

Re: set analysis basic

shiveshsingh — Tue, 30 Jan 2018 07:41:29 GMT

This means you are bypassing the fields, their selection in listbox(anywhere) will not change values in you chart.

DateNum={">=$(=Num(QuarterStart(Max(DateNum))))<=$(=Max(DateNum))"}

and regarding above, you will get sum of sales where datenum is greater than quarter start of max date and maxdate