Discussion Board for collaboration related to QlikView App Development.
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.
Try a condition show expression like this for your pie chart on the layout tab
GetSelectedCount(Product) = 0
View solution in original post
I think you should work on
At Layout insert condition:
if( SubStringCount( Concat(GetFieldSelections(Product),' '),'ProductName' )=0,1,0)
And at the ProductName, you can insert the value.
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.