topic Re: Busy Chart in QlikView

Busy Chart

Wed, 25 Nov 2020 16:16:04 GMT

I have a straight table which has 20 expression fields. This makes it busy. But whenever there is a filter applied this works just fine. I was wondering if there is a functionality which I can use to display the table only when its not busy or else display the message 'Select Filter1/Filter2/Filter3'

Re: Busy Chart

vishsaggi — Fri, 12 May 2017 13:27:51 GMT

Try this in your Straight table Chart General tab:

Re: Busy Chart

Kushal_Chawda — Fri, 12 May 2017 13:28:52 GMT

go to chart properties-> General Tab-> In calculated condition put below condition

getselectedcount(Filter1)>0 and getselectedcount(Filter2)>0 and getselectedcount(Filter3)>0

Now Click on Error Messages button, then click on Calculation condition unfulfilled and type

Please select Filter1/2/3

Re: Busy Chart

Fri, 12 May 2017 13:42:24 GMT

Thank you Vishwarath. That works fine. But when I have =GetSelectedCount(Filter1,Filter2,Filter3)>=1 on calculation condition it doesn't work. I have also tried or in place of , .

Re: Busy Chart

Fri, 12 May 2017 14:19:17 GMT

Thank you Kushal it worked