Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 means 1
>=1 means bigger than 1 or 1
So you have to take >1 or >=2
Its not working proper, cause it shows the values when i have nothing selected also.
Hello,
try GetSelectedCount(item) >= 1
Regards,
Brice
Hi
Your expression shows the "possible" count, you need the selected count.So like this:
= GetSelectedCount(item) >= 1
Regards
Jonathan
Try this
GetSelectedCount(item) > 1 or
coun(Distinct Item)>1