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: 
kinjal1645
Creator
Creator

Varaibles in Set analysis

Hi,

I have below expressions:

vBucket = if(($(vsumA) < $(vA_hurdle) or trim(len($(vsumA))) <=1) and ($(vsumB) < $(vB_hurdle) or trim(len($(vsumB)))<=1),  'Low Low',
if(($(vsumA) < $(vA_hurdle) or trim(len($(vsumA))) <=1) and $(vsumB) > $(vB_hurdle),         'Low High',
if($(vsumA) > $(vA_hurdle)         and ($(vsumB) < $(vB_hurdle) or trim(len($(vsumB)))<=1),  'High Low',
if($(vsumA) > $(vA_hurdle)         and $(vsumB) > $(vB_hurdle),         'High High'))))

vsumA = sum(A_num)/sum(A_den)

vsumB = sum(B_num)/sum(B_den)

Capture.PNG

 

I want to show following summary: count, vSumA and vSumB for each bucket

This summary shouldn't change based on user selection. 

I tried multiple things but couldn't find any solution.

Kindly help!

@sunny_talwar @swuehl @tresesco @Gysbert_Wassenaar 

 

Thanks

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

2 Replies
sunny_talwar

This?

image.png

kinjal1645
Creator
Creator
Author

Thanks Sunny 🙂