1 Reply Latest reply: May 11, 2016 9:10 AM by Sunny Talwar RSS

    Selected Value as a percentage of Total Values

    Patrice Veasey

      Hi All,

       

      I am using the gauge feature of QlikSense and I am trying to display my values as a percentage.

       

      I have a Count of "Count(Test Data)" which ends up giving a value of 220. However this 220 is not displayed as a percentage on the Gauge. This becomes a problem when I select various fields, for example, that have a count of 110 - this should be 50% of the data however it is still above the 100 line of the gauge.

       

      Does anyone know an expression to use in order to convert my Count(Test Data) into a percentage so it fits properly onto the gauge?

       

      Ideally it would avoid being a specific divide by 220 then multiplying by 100 as when other filters are applied this will skewer the real percentage.

       

      I hope this makes sense, any help is greatly appreciated.

       

      Thanks.