6 Replies Latest reply: Mar 16, 2015 11:28 PM by Jonathan Poole RSS

    Show non aggregated value in Guage

      I have a simple sheet with 2 columns which has been exported into Qlik Sense Desktop

       

      GEO   -  Sales

      US          100

      EU           50

      Asia         10

       

       

      I want 3 Guages to show sales for each GEO. I cant use the filter pane because it is global and will apply it to all guages.


      if I drop the Sales measure into the Guage it only provide options for aggregation (SUM, Count etc.)

       

      The only way I can get this to work is to add an expression to each guage .. If([GEO]='US',[Sales],0)

       

      Is there a better way of doing this ?