Varaibles in Set analysis

kinjal1645 — Sat, 16 Nov 2024 20:24:40 GMT

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)

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 @tresB @Gysbert_Wassenaar

Thanks

Re: Varaibles in Set analysis

sunny_talwar — Mon, 22 Jul 2019 17:15:16 GMT

This?

Re: Varaibles in Set analysis

kinjal1645 — Wed, 24 Jul 2019 10:52:08 GMT

Thanks Sunny 🙂

topic Varaibles in Set analysis in QlikView

Varaibles in Set analysis

Re: Varaibles in Set analysis

Re: Varaibles in Set analysis