Qliksense vizlib linechart: Auto number formatting)

[Revathi]

Hello folks!

I have created vizlib line chart which has year as a dimension and Amount as a measure.  In the expression i have used sum(Amount) and changed Auto number  . The number format abbreviation should change Dynamically. For some reason I am not able to show $ in the data points.  Example $100M. 

[Aditya_Chitale]

Try changing number format to 'Money' if option is provided. Else simple use foll expression: '$' & sum(Amount)

Regards,

Aditya

[Revathi]

Hi Aditya,

Thanks for the reply, if i use Money option,  have to hard code subtext M/B/K, I want these to automatically show in the data points and along with the dollar symbol.

$ & Sum(Amount) doesn't work.

[Aditya_Chitale]

If you want to show all figures in million, you will have to divide the measure by 1000000. 

As for showing the $ symbol before the value, add the $ symbol in single inverted commas 

='$' & sum(amount)

Regards,

Aditya