Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This is our if statement-
if(vAbsoluteThrshold=0,-1,fabs(sum({<$(='[$(premiumField)]')))>=vAbsolutethreshold)
vAbsoluteThrshold- This is the dependent expression, and using this in the pivot table
Ultimately above if expression need to be written by set analysis expression.
Kindly do the needful at earliest. Thanks in advance.
How about this:
Pick(Match(vAbsoluteThrshold,0)+1, fabs(sum({<$(='[$(premiumField)]')))>=vAbsolutethreshold, -1)
How about this:
Pick(Match(vAbsoluteThrshold,0)+1, fabs(sum({<$(='[$(premiumField)]')))>=vAbsolutethreshold, -1)
The vAbsoluteThrshold is an expression written in measure. Hence based on the 1 expression the 2nd expression is calculated and displayed in the pivot table. Hence any soultion we can do by P() and E() function????
Hi,
Pick() is not working with the variables in qlikview tried the below one but unable to achieve it.