Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make S$40141.77 display as S$40,141.77 ?

Hi All

I have expression from Mr Ram :-

'S$ ' & If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *Num(

sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)

,'###,##0.00')

I like to know how to make S$40141.77 display as S$40,141.77 ? i need a comma between 0 and 1 .

Paul

1 Solution

Accepted Solutions
Not applicable

'S$ ' & Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *Num(

sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)

,'###,##0.00'),'###,##0.00')

View solution in original post

7 Replies
paulyeo11
Master
Master
Author

my QVW

Not applicable

try this

Not applicable

'S$ ' & Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *Num(

sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)

,'###,##0.00'),'###,##0.00')

PrashantSangle

Hi,

In num(YourExpression,'###,##0.00')

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
PrashantSangle

Hi,

you can remove internal num formatting.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
kedar_dandekar
Creator
Creator

Hi Paul,

Try this expression:

'S$ ' & Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *

sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)

,'###,##0.00')

HTH

KD

paulyeo11
Master
Master
Author

Hi Kedar

Your and Ram answer are correct , thank you

Paul