topic Re: How do I make the Y-axis format dynamic in QlikView

How do I make the Y-axis format dynamic

bronsonelliott — Wed, 18 Feb 2015 01:53:55 GMT

I have an app where I have a list of metrics. Some of the metrics are expressed as absolute values while others are expressed as percentages.

I have my Actual format as such

=if([Metric Format] = 'Percent',

num(sum(Actual),'#,##0.0%'),

num(sum(Actual),'#,##0'))

And everything displays on the graph correctly except that the y-axis is not being properly formatted. How can I make the y-axis display correctly as '#,##0' or '#,##0.0%' list the actual value that's being displayed?

Re: How do I make the Y-axis format dynamic

rwunderlich — Wed, 18 Feb 2015 02:23:32 GMT

It may work if you move the if() to select just the format, not the aggregation.

num(sum(Actual)

,if([Metric Format] = 'Percent','#,##0.0%','#,##0'))

However, I find it easier to make two separate expressions and use the Expression conditional property to choose between them. That allows for use of the Number format, Axes, etc per expression.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: How do I make the Y-axis format dynamic

bronsonelliott — Wed, 18 Feb 2015 02:40:01 GMT

Thanks Rob! Your second suggestion of making separate expressions plus the conditional property is exactly what I need.