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

[sspawar88]

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]

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

[ciaran_mcgowan]

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]

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

what should i change there?

[Marcio_Campestrini]

Hi Satish

Try this: Scaling Numbers and DSE Tips | Qlikview Cookbook, by rwunderlich‌

[MK_QSL]

Scaling Numbers and DSE Tips | Qlikview Cookbook

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

[Marcio_Campestrini]

Satish

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