Discussion board where members can get started with QlikView.
How to set the Symbol as "Rs" instead of "$" in the result of this expression "='Average Line Total = '&Money(Avg(LineTotal))"?
Thanks in advance.
Go to Solution.
All the above will work but you will have to change for every expression. If you want to do the change document wise, go to the script editor, main tab, and change the following line
SET MoneyFormat='$#,##0.00;($#,##0.00)'; // Or the values you have from your Operating System locale configuration
Hope that helps.
Miguel Angel Baeyens
Comex Grupo Ibérica
Go to properties of chart -> Number -> Click on money -> Look for format pattern type,
Hope this will help you.
Not sure i have understood your Question. You want to change the money formate from $ to Rs. is it?
You could do it from Number table by changing the $ sign to Rs. or you could it with expression also using Num() function.
Have a look at the attached application.
Thanks all. Baeyens answer well fits mine.