How to change the number format for same expression?

[#1]

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

[its_anandrjs · Accepted solution]

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

[SunilChauhan]

only you need to change expression

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

see the attached file

hope this helps

[#4]

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

[its_anandrjs]

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

8%

4512

5%

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

See the attached sample file.

Rgds

Anand