Discussion board where members can get started with Qlik Sense.
I have the following expression which works :
I am trying to incorporate the below if statement into the above expression:
Go to Solution.
The rule of thumb is to have a single aggr(). I guess it would be something like:
View solution in original post
Try to create a flag in the script like below
if(Sum(if(Qlikdate4='Mon',NO_OF_TCKTS))/Sum(NO_OF_TCKTS)<0.02,1,0) as flag
then use this as expression