Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
UzunovM93
Contributor II
Contributor II

Dynamic Y-axis between absolute and percentages

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

1 Solution

Accepted Solutions
rwunderlich

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

View solution in original post

1 Reply
rwunderlich

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

View solution in original post