Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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