topic How to condition a simple expression in QlikView https://community.qlik.com/t5/QlikView/How-to-condition-a-simple-expression/m-p/965117#M650784 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am sure this is a silly-easy question but I am new and learning to please be patient :</P><P>I have the following expression in a Pivot Table Chart with Sales and Day\Month\Year dimensions (among others) :&nbsp; </P><P><STRONG style="text-decoration: underline;"><BR /></STRONG></P><P><STRONG style="text-decoration: underline;">Sum (sales) - Above (Sum (Sales))</STRONG></P><P></P><P>How Can I add a condition that when sum (sales) = 0&nbsp; than&nbsp; either show an error or do not show any value for the expression in the Chart</P><P>(Since when Sum can not be zero, it indicate the data was not loaded in that Date)</P><P>(Sum (sales) - Above (Sum (Sales)))</P><P></P><P>Thank</P><P></P><P>Nir&nbsp; </P></BODY></HTML> Thu, 03 Sep 2015 08:05:18 GMT 2015-09-03T08:05:18Z How to condition a simple expression https://community.qlik.com/t5/QlikView/How-to-condition-a-simple-expression/m-p/965117#M650784 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am sure this is a silly-easy question but I am new and learning to please be patient :</P><P>I have the following expression in a Pivot Table Chart with Sales and Day\Month\Year dimensions (among others) :&nbsp; </P><P><STRONG style="text-decoration: underline;"><BR /></STRONG></P><P><STRONG style="text-decoration: underline;">Sum (sales) - Above (Sum (Sales))</STRONG></P><P></P><P>How Can I add a condition that when sum (sales) = 0&nbsp; than&nbsp; either show an error or do not show any value for the expression in the Chart</P><P>(Since when Sum can not be zero, it indicate the data was not loaded in that Date)</P><P>(Sum (sales) - Above (Sum (Sales)))</P><P></P><P>Thank</P><P></P><P>Nir&nbsp; </P></BODY></HTML> Thu, 03 Sep 2015 08:05:18 GMT https://community.qlik.com/t5/QlikView/How-to-condition-a-simple-expression/m-p/965117#M650784 2015-09-03T08:05:18Z Re: How to condition a simple expression https://community.qlik.com/t5/QlikView/How-to-condition-a-simple-expression/m-p/965118#M650786 <HTML><HEAD></HEAD><BODY><P>Something like.</P><P></P><P>If(<STRONG style="text-decoration: underline;">Sum (sales) - Above (Sum (Sales))&lt;</STRONG>&gt;0, <STRONG style="text-decoration: underline;">Sum (sales) - Above (Sum (Sales))</STRONG>, 'Not Avail.') </P></BODY></HTML> Thu, 03 Sep 2015 08:07:37 GMT https://community.qlik.com/t5/QlikView/How-to-condition-a-simple-expression/m-p/965118#M650786 alexandros17 2015-09-03T08:07:37Z Re: How to condition a simple expression https://community.qlik.com/t5/QlikView/How-to-condition-a-simple-expression/m-p/965119#M650787 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>If(Sum(sales) &lt;&gt; 0, Sum(sales) - Above(Sum(Sales)))</STRONG></P></BODY></HTML> Thu, 03 Sep 2015 08:11:16 GMT https://community.qlik.com/t5/QlikView/How-to-condition-a-simple-expression/m-p/965119#M650787 sunny_talwar 2015-09-03T08:11:16Z