Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

set analysis basic

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


2 Replies
sunny_talwar

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)

shiveshsingh
Master
Master

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