Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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