2 Replies Latest reply: Feb 23, 2018 7:32 AM by sai kishore RSS

    Sum with conditional Expr

    Anirban Musib

      Hi,

       

      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 & Net Gross.

      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).

       

      Thank you

      Anirban