Multiple Value in if Statement

[vijayit43]

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.

[MK_QSL]

Provide Sample data...

[israrkhan]

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))

[preminqlik]

sum(Quantity*(25*$(=getselectedcount(Week)))/100)