Dynamic Y-axis between absolute and percentages

[UzunovM93]

Hi all, 

I am trying to create a scorecard with some line charts in it, however, I am unable to make the Y-axis dynamic between absolute and percentage values for different metrics. I am using the formula in the attached which works in a straight table but doesn't in a line chart:

=NUM(Value,IF(Whatever = 'Percentage','##.#0%','##'))

I have tried many suggestions in other topics like wrapping it in TEXT() or using the IF statement first but none of them helped. I am using QlikView 11. 

Thanks

[rwunderlich · Accepted solution]

If you want to change the actual axis display, I believe you will have to change it at the Number settings.  Which means two expressions with a conditional property.  See attached. 

-Rob