Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.