Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QLikViewReport Filter We Use Week (Week-1,Week-2,Week-3,Week-4) When Select Week-1 Then Sum(Quantity*25/100)as so onIts Warking ,
But We Want To Select (Week-1 & Week-2 ) Then Sum(Quantity*50/100) How is Possible.
Provide Sample data...
try GetSlectedCount function to see how many values are selected in the week field, than try like below
=if(getselectedcount(yourfieldname==2), Sum(Quantity*50/100), Sum(Quantity*25/100))
sum(Quantity*(25*$(=getselectedcount(Week)))/100)