Replacement for Getselectedcount

mohan2391 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 1 button and 2 filters. Based on the selection on these, my chart should show data

I have default selection on Year=2018

I have requirement like if

(1) OFF & month: OFF is selected from button and any 1 or more values selected from 'month' then it should show sum(A)

(2) OFF & year: OFF is selected from button and no value from 'month' is selected, then it should show sum(B)

(3) ON & month: ON is selected from button and any 1 or more values selected from 'month' then it should show sum(C)

(4) ON & year: ON is selected from button and no value from 'month' is selected, then it should show sum(D)

To achieve this, I used this below expression

if(GetSelectedCount(month)>0,

if(vOFFON=0,sum(A),sum(C)),

if(vOFFON=0,sum(B),sum(D)))

But it is running for long time and finally displays 'Calculation Timed Out'. i need an alternate expression for this

For test purpose, when i tried with either "if(vOFFON=0,sum(A),sum(C))" or if(vOFFON=0,sum(B),sum(D))

it is responding in fraction of seconds.

But when i combine all conditions with the help of Getselectedcount, it is not responding

Please help me

Regards

Krishna

topic Replacement for Getselectedcount in QlikView