Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Solution

Accepted Solutions
Highlighted

2 Replies
Highlighted

Highlighted
Creator
Creator

Thanks Sunny 🙂