Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Changing the symbol from $ to Rs in Money Function

Hi All,

How to set the Symbol as "Rs" instead of "$" in the result of this expression "='Average Line Total = '&Money(Avg(LineTotal))"?

Thanks in advance.

1 Solution

Accepted Solutions

Re: Changing the symbol from $ to Rs in Money Function

Hi,

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

to

SET MoneyFormat='Rs#,##0.00;(Rs#,##0.00)';

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

4 Replies

Changing the symbol from $ to Rs in Money Function

Hi,

    Go to properties of chart -> Number -> Click on money -> Look for format pattern type,

    Rs:#,##0;-Rs:#,##0

    Hope this will help you.

Regards,

Kaushik Solanki

   

Not applicable

Re: Changing the symbol from $ to Rs in Money Function

Hi,

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.

- Sridhar

Re: Changing the symbol from $ to Rs in Money Function

Hi,

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

to

SET MoneyFormat='Rs#,##0.00;(Rs#,##0.00)';

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable

Re: Changing the symbol from $ to Rs in Money Function

Thanks all. Baeyens answer well fits mine.