topic how to use getselectedcount? in QlikView

how to use getselectedcount?

jim_chan — Thu, 04 Aug 2016 04:19:05 GMT

Hi guys,

i have created a bar chart. i have dimension Month and Day.

So my scenario is....

when i have did not select any month - the bar chart willl show me jan - dec.

when i selected Jan - it will show me 1 - 31 day of thet month , in the bar chart

How to do that with getselectedcount? like this??? if(getselectedcount(Month)=1,1,0) , doesnt seem to work

rgds,

jim

Re: how to use getselectedcount?

Thu, 04 Aug 2016 04:23:40 GMT

Use like below,

if(getselectedcount(Month)>0,1,0)

Re: how to use getselectedcount?

Greg_Williams — Thu, 04 Aug 2016 04:29:36 GMT

Check THIS out.

Re: how to use getselectedcount?

sunny_talwar — Thu, 04 Aug 2016 04:36:21 GMT

May be you need to use a calculated dimension in this case

If(GetSelectedCount(Month) = 1, Days, Month)

The above calculated dimension will show days if 1 month is selected, else it will show Month field for multiple selections in Month field or no selection in Month field.