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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional count show values

Hello, i have a graph where i only want to show values if an item from listbox is selected or more.

if i do this =count(distinct item) = 1

Then the graph will show when i select one.

How do make the graph show when i select more than one value?

cause if i do like this coun(distinct item) >= 1 then it shows all the time.

Thanks in advance

1 Solution

Accepted Solutions
Brice-SACCUCCI
Employee
Employee

Hello,

try GetSelectedCount(item) >= 1

Regards,

Brice

View solution in original post

5 Replies
Not applicable
Author

= 1 means 1

>=1 means bigger than 1 or 1

So you have to take >1 or >=2

Not applicable
Author

Its not working proper, cause it shows the values when i have nothing selected also.

Brice-SACCUCCI
Employee
Employee

Hello,

try GetSelectedCount(item) >= 1

Regards,

Brice

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Your expression shows the "possible" count, you need the selected count.So like this:

= GetSelectedCount(item) >= 1

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
er_mohit
Master II
Master II

Try this

GetSelectedCount(item) > 1 or

coun(Distinct Item)>1