Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jjordaan
Partner - Specialist
Partner - Specialist

Variable in the string variable MoneyFormat

Hello everyone,

I'm making a dashboard linked to a NAV database.

Within this NAV database there is setting ocal currency with the corresponding symbol. I have putted this currency symbol in a variable.

Now I want this variable added to the moneyformat in the script.

something like

SET MoneyFormat ='$(vCurrSymbol) & #, ## 0.00; -$(vCurrSymbol) & #, ## 0.00";

Only I do not get the right result. The variable is displayed as text.

Can anyone help me?

Thank you very much

13 Replies
jjordaan
Partner - Specialist
Partner - Specialist
Author

Sorry for my misunderstanding, I'm not working with QV for that long but I don't see how I can do that

whiteline
Master II
Master II

When you load SaleslineAmount, you can use instead:

dual(CurrencyCodesSymbol & ' ' & num(SaleslineAmount, '#,##0.00', '.' , ','), SaleslineAmount) as SaleslineAmount,

but field CurrencyCodesSymbol should be in the same source table.

jjordaan
Partner - Specialist
Partner - Specialist
Author

Thank you very much for your help

whiteline
Master II
Master II

This trick with text representation works not only with tables but also with charts (values on data point and so on).