Combo Chart - changing showen value on line chart

[#1]

Hello,

I have on line -> ratio of Sales and Budget. Values are for example 96% or 103%.

I want to see only -4 % or 3 %. Is possible to do this and preserve the line position?

Thankso much you for answers!

[whiteline · Accepted solution]

Hi.

Use dual() function to change text representation, for example:

=dual(Sales/Budget-1, Sales/Budget)

Don't forget to change a number format to 'Expression Default'.

[#3]

Hi,

thank you! It's working.

Is possible to format it on required format for example -4%. Because when I use NUM function, it will do 96% again.

Tahnk you, Mirek

[whiteline]

Yes. But you should use it in the right way.

=dual(num(Sales/Budget-1, '0%'), Sales/Budget)

[#5]

It's work and it's perfect. Thank you so much once again!

[#6]

Can I have one more question please? Could you please look on this

http://community.qlik.com/message/260745#260745

if is possible to find solution for this? Or it is a waste of time..

thx