topic Re: Hide one value when another value is selected in QlikView

Hide one value when another value is selected

psk180590 — Thu, 09 Feb 2017 15:02:19 GMT

Hello all,

I have a dashboard where i would like to hide a particular Pie-Chart when an other value is selected.

Ex: Consider i have Product(as dropdown box) and Market(as Pie-Chart) values in my dashboard.

I'm now seeing both by default, but when a user selects a particular Product the Pie showing market results must disappear.

TIA!!

sunny_talwar — Thu, 09 Feb 2017 15:08:00 GMT

Try a condition show expression like this for your pie chart on the layout tab

GetSelectedCount(Product) = 0

Anonymous — Thu, 09 Feb 2017 15:09:03 GMT

I think you should work on

Pie chart:

Properties..>Layout...>Conditional...>

Anonymous — Thu, 09 Feb 2017 15:09:16 GMT

At Layout insert condition:

if( SubStringCount( Concat(GetFieldSelections(Product),' '),'ProductName' )=0,1,0)

And at the ProductName, you can insert the value.

psk180590 — Thu, 09 Feb 2017 15:14:53 GMT

Thanks All for the quick suggestions.

stalwar1‌ your suggestion worked for me.

I was trying with a Count(distinct) and the chart would disappear completely. But, now it perfectly suits my requirement.

Thanks Again!!