topic Hiding a chart based on a condition in QlikView https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300011#M498400 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Something like this perhaps?</P><P></P><P>Max(aggr(count distinct Order_No, Year, Product)) &gt; 3</P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Fri, 22 Jul 2011 14:26:50 GMT jonathandienst 2011-07-22T14:26:50Z Hiding a chart based on a condition https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300008#M498397 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Chart needs to be hided when there is no data to display.</P><P></P><P>Chart contains Year and Product as a dimension and count(distinct Order_No) as a expression.</P><P></P><P>This chart should be displayed when count(distinct Order_No)&gt;3...</P><P></P><P>I have attached the sample file... </P></BODY></HTML> Fri, 22 Jul 2011 12:54:18 GMT https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300008#M498397 2011-07-22T12:54:18Z Hiding a chart based on a condition https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300009#M498398 <HTML><HEAD></HEAD><BODY><P>Just go to the charts Properties, then to the Layout tab.</P><P></P><P>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.</P><P></P><P>Just put your statement&nbsp; "count(distinct Order_No)&gt;3" and that will do it.</P></BODY></HTML> Fri, 22 Jul 2011 12:57:03 GMT https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300009#M498398 markmccoid 2011-07-22T12:57:03Z Re: Hiding a chart based on a condition https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300010#M498399 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If we give&nbsp; 'count(distinct Order_No)&gt;3' it wont consider the dimensions...it will check this condition globally...</P><P></P><P>If none of the Year&amp;Prod_Id has count(distinct Order_No)&gt;3 then only we need to hide the sheet.</P><P></P><P>Please see the attachment...</P></BODY></HTML> Fri, 22 Jul 2011 13:10:52 GMT https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300010#M498399 2011-07-22T13:10:52Z Hiding a chart based on a condition https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300011#M498400 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Something like this perhaps?</P><P></P><P>Max(aggr(count distinct Order_No, Year, Product)) &gt; 3</P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Fri, 22 Jul 2011 14:26:50 GMT https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300011#M498400 jonathandienst 2011-07-22T14:26:50Z Hiding a chart based on a condition https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300012#M498401 <HTML><HEAD></HEAD><BODY><P> Or probably Min....</P><P></P><P>Jonathan</P></BODY></HTML> Fri, 22 Jul 2011 14:28:09 GMT https://community.qlik.com/t5/QlikView/Hiding-a-chart-based-on-a-condition/m-p/300012#M498401 jonathandienst 2011-07-22T14:28:09Z