Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

'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')

7 Replies
paulyeo11
Valued Contributor II

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

my QVW

Not applicable

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

try this

Not applicable

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

'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')

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

Hi,

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

Regards,

Regards,
Prashant Sangle

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

Hi,

you can remove internal num formatting.

Regards

Regards,
Prashant Sangle
kedar_dandekar
Contributor

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

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
Valued Contributor II

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

Hi Kedar

Your and Ram answer are correct , thank you

Paul

Community Browser