topic Gauge Chart Numaric Values in QlikView

Gauge Chart Numaric Values

Thu, 21 May 2015 07:22:49 GMT

I have a requirement like in gauge chart i have to mention the values of numeric in 2K(form)

for example 200000-should display as 2K.I placed thousand symbol in number tab but its not working

jyothish8807 — Thu, 21 May 2015 07:26:42 GMT

Hi,

You can try like this in your expression:

=Dual(sum(Sales)/1000 &'K',Sum(Sales)/1000))

Regards

tresB — Thu, 21 May 2015 07:47:58 GMT

Change your expression to something like:

Num(YourExistingExpression/1000, '$ #,##0.00K;$ -#,##0.00K')

Thu, 21 May 2015 07:59:31 GMT

Its working but not completely because my requirement is 98.5K

jyothish8807 — Thu, 21 May 2015 08:34:00 GMT

Hi Yeshu,

You can set it to decimal place as 1 in number tab.

Hope it helps.

Regards