Discussion Board for collaboration related to Creating Analytics for QlikView.
Chart needs to be hided when there is no data to display.
Chart contains Year and Product as a dimension and count(distinct Order_No) as a expression.
This chart should be displayed when count(distinct Order_No)>3...
I have attached the sample file...
Go to Solution.
Something like this perhaps?
Max(aggr(count distinct Order_No, Year, Product)) > 3
Hope that helps
Just go to the charts Properties, then to the Layout tab.
On the Layout tab you will find "Show" section that let's you enter a conditional statement to determine whether or not to show the chart.
Just put your statement "count(distinct Order_No)>3" and that will do it.
If we give 'count(distinct Order_No)>3' it wont consider the dimensions...it will check this condition globally...
If none of the Year&Prod_Id has count(distinct Order_No)>3 then only we need to hide the sheet.
Please see the attachment...
Or probably Min....