topic Re: How to format a expression label as currency? in QlikView

How to format a expression label as currency?

Fri, 06 Dec 2013 15:43:27 GMT

Hi,

How to format a expression label as currency value ?

For example - 2000000 should be formatted to #,##0;(#,##0)

Appreciate your help

Thank you

jerem1234 — Fri, 06 Dec 2013 15:47:34 GMT

You can use num(NUMBER, '#,##0;(#,##0)')

Hope this helps!

fred_s — Fri, 06 Dec 2013 15:53:01 GMT

Hi Dimple,

Maybe this way:

money(#,##0;(#,##0))

Fri, 06 Dec 2013 15:56:57 GMT

The chart legend show the actual function name and number like num(30000000,'#,##0;(#,##0)')

I am trying to apply the formatting to the label in the expression but it display the actual script in it

Fri, 06 Dec 2013 15:58:03 GMT

My bad sorry I will fix it , missed "="

fred_s — Fri, 06 Dec 2013 15:59:05 GMT

Is it possible to attach your file?

jerem1234 — Fri, 06 Dec 2013 15:59:17 GMT

You need to add an =.

Try this in your label:

=num(30000000, '#,##0;(#,##0)')

Hope this helps!