Dynamic Y-axis between absolute and percentages

UzunovM93 — Thu, 13 May 2021 10:15:52 GMT

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

Re: Dynamic Y-axis between absolute and percentages

rwunderlich — Thu, 13 May 2021 20:30:14 GMT

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

topic Dynamic Y-axis between absolute and percentages in QlikView

Dynamic Y-axis between absolute and percentages

Re: Dynamic Y-axis between absolute and percentages