topic Re: Combo Chart - changing showen value on line chart in QlikView

Combo Chart - changing showen value on line chart

Sun, 23 Sep 2012 09:38:10 GMT

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 — Sun, 23 Sep 2012 09:53:17 GMT

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'.

Sun, 23 Sep 2012 10:14:52 GMT

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 — Sun, 23 Sep 2012 10:22:00 GMT

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

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

Sun, 23 Sep 2012 11:24:02 GMT

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

Sun, 23 Sep 2012 11:28:44 GMT

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

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

thx