topic How to change the number format for same expression? in QlikView

How to change the number format for same expression?

Fri, 14 Oct 2011 05:59:43 GMT

Hi All,

I have attached the app, in which I crosstab the table.

In the dimension I took the Qualifier field & Attribute field and data field as expression.

Now what I want is in that chart (demo) first 2 fields Net Sale & Net Rev are nos and Net Margin in %, so how can I change the number format for same expression.

Thanks in Advance

Upendra

Re: How to change the number format for same expression?

its_anandrjs — Fri, 14 Oct 2011 06:08:56 GMT

Hi,

You can use a code for Sum(Data) so use some thing like below

=If(FF = 'Net Margin',Round( Num( Sum(Data)*100,'#.##' ),1 )&'%' ,Sum(Data))

See atttached sample also in Solution Sheet.

Rgds

Anand

Re: How to change the number format for same expression?

SunilChauhan — Fri, 14 Oct 2011 06:12:14 GMT

only you need to change expression

=if(FF='Net Margin',NUm(sum(Data),'#.##%'),sum(Data))

see the attached file

hope this helps

How to change the number format for same expression?

Fri, 14 Oct 2011 07:43:01 GMT

here is the Qlikview built-in option to change display

right click your chart -> 'properties' -> 'number' tab -> choose the expression you want to override format.

select the format option in right hand panel.

done.

hope this help.

regards

mingming

Re: How to change the number format for same expression?

its_anandrjs — Fri, 14 Oct 2011 07:50:50 GMT

Hi,

If you change the setting of chart to the Number for the chart then the all other value should change so if there is two type of values like

451

4512

you have to deside which value shown in % or number.

See the attached sample file.

Rgds

Anand