Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smithaprabhakar
Partner - Contributor
Partner - Contributor

Conversion of if statement to set analysis in qlikview

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.

 

 

 

 

 

1 Solution

Accepted Solutions
Huiying
Partner - Creator III
Partner - Creator III

How about this:

Pick(Match(vAbsoluteThrshold,0)+1, fabs(sum({<$(='[$(premiumField)]')))>=vAbsolutethreshold, -1)

View solution in original post

3 Replies
Huiying
Partner - Creator III
Partner - Creator III

How about this:

Pick(Match(vAbsoluteThrshold,0)+1, fabs(sum({<$(='[$(premiumField)]')))>=vAbsolutethreshold, -1)

smithaprabhakar
Partner - Contributor
Partner - Contributor
Author

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

smithaprabhakar
Partner - Contributor
Partner - Contributor
Author

Hi,

 

 

Pick() is not working with the variables in qlikview tried the below one but unable to achieve it.