topic Re: How to put Dollar sign in QlikView

How to put Dollar sign

AH — Wed, 03 Dec 2014 17:38:09 GMT

Hi I have textbox which provides me some amount in dollar. I want to put a $ sign before the price amount. the expression behind the text box is:

=num(Sum({<[ItemID] = {'SA', 'CP' }>} TotalInvoiceInFunCur),'##,##0')

Thanks,

Shan

oscar_ortiz — Wed, 03 Dec 2014 17:42:00 GMT

Simply try:

=num(Sum({<[ItemID] = {'SA', 'CP' }>} TotalInvoiceInFunCur),'$##,##0')

Good luck

Oscar

its_anandrjs — Wed, 03 Dec 2014 17:42:57 GMT

Hi,

Try like

='$'&num(Sum({<[ItemID] = {'SA', 'CP' }>} TotalInvoiceInFunCur),'##,##0')

Regards

Anand

AH — Wed, 03 Dec 2014 17:47:45 GMT

Thanks Guys. Both way it works.

Regards

Shan