Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

 

Highlighted
Contributor III
Contributor III

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)