topic Re: How should we write the expression in this condition............? in QlikView https://community.qlik.com/t5/QlikView/How-should-we-write-the-expression-in-this-condition/m-p/1046298#M351740 <HTML><HEAD></HEAD><BODY><P>Try this expression: if(sum(total &lt;Sales_Man,Order_id&gt; Fact_X-Fact_Y)&gt;30000,sum(Fact_X-Fact_Y))</P></BODY></HTML> Sun, 10 Jan 2016 16:41:00 GMT Gysbert_Wassenaar 2016-01-10T16:41:00Z How should we write the expression in this condition............? https://community.qlik.com/t5/QlikView/How-should-we-write-the-expression-in-this-condition/m-p/1046296#M351738 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a Pivot table with fields Sales_man,Order_ID,Product_ID,Fact_X,Fact_Y,Fact_Z.</P><P></P><P>Here one Order_ID consists of Different Product_ID's and Fact_Z&nbsp; is derived&nbsp; from <SPAN style="font-size: 13.3333px;">Fact_X,Fact_Y( Fact_Z=<SPAN style="font-size: 13.3333px;">Fact_X - Fact_Y ) and as per my requirement I want to see&nbsp; this Pivot table chat <SPAN style="font-size: 13.3333px;"> results with only Fact_Z &gt; 30000.</SPAN></SPAN></SPAN></P><P></P><P>I mentioned above condition expression in every filed to get this result but I couldn't get&nbsp; correct result.The below highlighted in the image is the <SPAN style="font-size: 10pt; line-height: 1.5em;">Expected result.Kindly provide the solution for this scenario.</SPAN></P><P><IMG alt="Image.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/110938_Image.JPG" style="height: 200px; width: 620px;" /></P></BODY></HTML> Thu, 07 Jan 2016 18:42:31 GMT https://community.qlik.com/t5/QlikView/How-should-we-write-the-expression-in-this-condition/m-p/1046296#M351738 srinivas1921 2016-01-07T18:42:31Z Re: How should we write the expression in this condition............? https://community.qlik.com/t5/QlikView/How-should-we-write-the-expression-in-this-condition/m-p/1046297#M351739 <HTML><HEAD></HEAD><BODY><P>Are you able to share a sample where you are trying this out?</P></BODY></HTML> Thu, 07 Jan 2016 18:44:29 GMT https://community.qlik.com/t5/QlikView/How-should-we-write-the-expression-in-this-condition/m-p/1046297#M351739 sunny_talwar 2016-01-07T18:44:29Z Re: How should we write the expression in this condition............? https://community.qlik.com/t5/QlikView/How-should-we-write-the-expression-in-this-condition/m-p/1046298#M351740 <HTML><HEAD></HEAD><BODY><P>Try this expression: if(sum(total &lt;Sales_Man,Order_id&gt; Fact_X-Fact_Y)&gt;30000,sum(Fact_X-Fact_Y))</P></BODY></HTML> Sun, 10 Jan 2016 16:41:00 GMT https://community.qlik.com/t5/QlikView/How-should-we-write-the-expression-in-this-condition/m-p/1046298#M351740 Gysbert_Wassenaar 2016-01-10T16:41:00Z