Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Replacement for Getselectedcount

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

aaaa.PNG

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