Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like this
=if(Measurement = 'Margin', Num(Expression, '#,##0.0%'), Num(Expression, '#,##0.#0')
Number tab -> check the Expression Default.
hope it helps
Hello ,
Yes , you can mix. You need to do all the formatting in script and then in chart just select expression default.
BR
Serhan
Hi
Try like this
=if(Measurement = 'Margin', Num(Expression, '#,##0.0%'), Num(Expression, '#,##0.#0')
Number tab -> check the Expression Default.
hope it helps
You could use an if condition in the expression