Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try using this expression:
Count([Test Data])/Count({1} TOTAL [Test Data])
May be try using this expression:
Count([Test Data])/Count({1} TOTAL [Test Data])