Swedish krona standard in Qlikview?

[#1]

HI,

How can I put the following currency standard in Qlikview chart currency format

150 256,50kr

Arif

[#2]

Arif

you can use symbol in tab "number"

Chris

[whiteline]

Hi.

[Anonymous]

Hi,

The default format for currency, dates etc. is set in the script as variables. On a Swedish system it looks like this.

ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 kr;-#.##0,00 kr';
SET TimeFormat='hh:mm:ss';
SET DateFormat='YYYY-MM-DD';
SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';
SET MonthNames='jan;feb;mar;apr;maj;jun;jul;aug;sep;okt;nov;dec';
SET DayNames='må;ti;on;to;fr;lö;sö';

However you can always change this on the Number tab in the chart properties.

[#5]

HI,

The above method worked well when I format the number for number property of the chart. However, when I try to use this pattern in an expression, it does not work well

num(sum(revenue),'# ##0,00 kr') gives me 333417 ##0,00

while the same expression in the number property gives 333 416,67

How to fix this?

Arif

[Anonymous]

Ahh, now that can happen sometimes. Just copy the format from numbers tab and then past it into the expression. It might sound a bit strange but even though you type the exact same format it sometimes only works  when copying it....

[#7]

tried multiple times but not working on expression

Arif

[Anonymous]

Try this

num(Sum(Antal),'# ##0,00 Kr')

[ashwanin]

Hi Arif,

Syed is correct, if your QV is other than Swedish and you want to reflect the swedish Krona in QVW then change the currency format of your QV application to SET MoneyFormat='#.##0,00 kr;-#.##0,00 kr'; in script. inwhich you want the currency as Swedish Krona.

[whiteline · Accepted solution]

You have to set two additional parameters for num() function: decimal-sep and thousands-sep symbols.