topic Re: Large Number on Chart dynamically Need to be Million, Thousand & Hundred in QlikView

Large Number on Chart dynamically Need to be Million, Thousand & Hundred

sspawar88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

i Have done all setting to get the figures like 11.16,8.72,5.10 in Chart.

What should change in chart to get the Required Decimals ?

Anonymous — Wed, 22 Jun 2016 13:06:18 GMT

Just to right of the "Fixed to" you have selected enter the number of decimals you want.

ciaran_mcgowan — Wed, 22 Jun 2016 13:12:51 GMT

Hi Satish,

I usually create an expression like:

Dual(

if([your formula] > 1000000,

Num([your formula]/1000000,'#,##0.0') & ' Million',

if([your formula] > 1000,

Num([your formula]/1000,'#,##0.0') & ' Thousand',

Num([your formula]/100,'#,##0.0') & ' Hundred'

)))

[your formula]

)

The Dual function means that the formula within the if statement is displayed but your original formula is what will be mapped in the chart.

sspawar88 — Wed, 22 Jun 2016 13:14:12 GMT

I want figures in chart like 11.16,8.72,5.10 etc

what should i change there?

Marcio_Campestrini — Wed, 22 Jun 2016 13:21:13 GMT

Hi Satish

MK_QSL — Wed, 22 Jun 2016 13:22:23 GMT

Ohhh... marcio.campestrini has already posted this..!

Marcio_Campestrini — Tue, 12 Jul 2016 11:59:16 GMT

Satish

Have you solved your issue? If you did, choose the right question to help us to keep community clean.