Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

how to use getselectedcount?

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

1 Solution

Accepted Solutions
sunny_talwar

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.

View solution in original post

3 Replies
Not applicable

Use like below,

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

Greg_Williams
Former Employee
Former Employee

Check THIS out.

sunny_talwar

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.