topic Re: conditional count show values in QlikView

conditional count show values

Mon, 09 Sep 2013 11:18:24 GMT

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

Mon, 09 Sep 2013 11:23:56 GMT

= 1 means 1

>=1 means bigger than 1 or 1

So you have to take >1 or >=2

Mon, 09 Sep 2013 11:26:55 GMT

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

Brice-SACCUCCI — Mon, 09 Sep 2013 11:27:45 GMT

Hello,

try GetSelectedCount(item) >= 1

Regards,

Brice

jonathandienst — Mon, 09 Sep 2013 11:30:53 GMT

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

= GetSelectedCount(item) >= 1

Regards

Jonathan

er_mohit — Mon, 09 Sep 2013 11:31:42 GMT

Try this

GetSelectedCount(item) > 1 or

coun(Distinct Item)>1