Combine diferrent units in chart

[Anonymous]

Hi,

I would like to create a combined chart (straight table) of different "value types"/units.

Example:

Measurement	Value
Revenue	10.000
Contribution	2.000
Margin	20,0%

Is that possible in QlikView?

I only have one dimension, Measurement. At the Chart proporties, I can only chose one single "value type"/unit at the Number tab, stating if I would like a percent sign... Can I mix unit in the same chart?

Thanks for your replies.

Best regards,

Filip

[Anonymous]

Hello ,

Yes , you can mix. You need to do all the formatting in script and then in chart just select expression default.

BR

Serhan

[MayilVahanan · Accepted solution]

Hi

Try like this

=if(Measurement = 'Margin', Num(Expression, '#,##0.0%'), Num(Expression, '#,##0.#0')

Number tab -> check the Expression Default.

hope it helps

[sasiparupudi1]

You could use an if condition in the expression