Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Support
Support

The Symbols in the Bar Chart do not change from Thousand to Millions

fdsfdfddfs.PNG

Even though the value is in the millions the Bar Chart still shows the thousand symbol. The Bar Chart should display the appropriate symbol if it is millions or thousands. The Bar Chart shows the thousands symbol even though the value is in the millions.

My expression is:

money(sum({<Year = , Month=, [Matl Owner Ind]={'1'}>} $(eSales)), '$#,##0;('&'$#,##0)')

 

Any responses appreciated! THANK YOU!

1 Reply
Claudiu_Anghelescu
Contributor III

Re: The Symbols in the Bar Chart do not change from Thousand to Millions

Check the format in the script, the tab MAIN
SET MoneyFormat='#.##0,00 $;-#.##0,00 $';
To help community find solutions, please don't forget to mark as correct.