Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nikita23
Contributor III
Contributor III

How to change number into currency in TEUR (thousand Euros)

Hi All,

I'm having trouble representing numbers in TEUR format. What I actually want to do is to convert number (1,20M) to change into   a thousand euro(TEUR) sign at the end separated by space like  ("1.200 TEUR" e.g.).

Could you please me how to achieve this in Qliksense Dashboard.

 

Many thanks in advance!

2 Replies
vunguyenq89
Creator III
Creator III

HI, you can set parameter Number formatting = Measure expression, divide the actual number by 1000 and apply a format string with Num() function. For example

=Num(Sum(Sales)/1000,'###,## TEUR')

result.png

Hope this helps

BR, 

Vu Nguyen

 

nikita23
Contributor III
Contributor III
Author

Hi Vu Nguyen,

I am able to change the number in to EUR by applying below formula but not able to convert the same into TEUR(Thousand Euros)

#.##0 EUR ; -#.##0 EUR

e.g 1.200.000 EUR (Converted into the same)

are 1.200 TEUR (Not able to convert it into like this)

 

Could you please help me to convert this number into Thousand Euros(TEUR)