topic Re: Different format in field in QlikView

Different format in field

Sat, 26 Apr 2014 15:21:28 GMT

Hi everyone,

Is there a way to have different number format on the same field like on the picture below.

What I want is PBT MARGIN and PAT MARGIN to have format in percent like '#.###%' and all other value to have format like '##.###'.

Should I solve this in script or I can manage this in chart.

Hope you can help me.

PrashantSangle — Sat, 26 Apr 2014 15:23:40 GMT

Hi,

Yes you can do,

In expression you can write

Num(youExpression,'#.###%')

Regards,

preminqlik — Sat, 26 Apr 2014 16:07:19 GMT

if(dimension='PAT MARGIN' or dimension='PBT Margin',

num([percentage expression,'#,###%'),

num(sum(Amount),'##.###'))

Clever_Anjos — Sat, 26 Apr 2014 16:58:28 GMT

There´re two or more ways, PFA an example