Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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