topic Custom Expression for Sum with condition in QlikView https://community.qlik.com/t5/QlikView/Custom-Expression-for-Sum-with-condition/m-p/78215#M458496 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a Gauge in Qlik Dashboard showing total gross sales. I have five columns in the table: Sale ID , Qty, Unit Sales Price, unit Purchase Price &amp; Net Gross.</P><P>I would like to show Total Gross when Unit Sales Price is higher than Unit sales price and I would also like to show Count of Sales ID when Unit SAles price is higher than Unit Purchase Price.( both custom measures).</P><P></P><P>Thank you</P><P>Anirban</P></BODY></HTML> Fri, 23 Feb 2018 10:37:01 GMT Anonymous 2018-02-23T10:37:01Z Custom Expression for Sum with condition https://community.qlik.com/t5/QlikView/Custom-Expression-for-Sum-with-condition/m-p/78215#M458496 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a Gauge in Qlik Dashboard showing total gross sales. I have five columns in the table: Sale ID , Qty, Unit Sales Price, unit Purchase Price &amp; Net Gross.</P><P>I would like to show Total Gross when Unit Sales Price is higher than Unit sales price and I would also like to show Count of Sales ID when Unit SAles price is higher than Unit Purchase Price.( both custom measures).</P><P></P><P>Thank you</P><P>Anirban</P></BODY></HTML> Fri, 23 Feb 2018 10:37:01 GMT https://community.qlik.com/t5/QlikView/Custom-Expression-for-Sum-with-condition/m-p/78215#M458496 Anonymous 2018-02-23T10:37:01Z