Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
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