topic chart expression, show as percent issue in QlikView

chart expression, show as percent issue

BarbCline — Fri, 09 Sep 2011 16:15:24 GMT

I have a combo chart that has data on both the left and right axes. Left axes is number, right axes is percent. Starting out, the formats are great. When I dynamically change the chart (either by Fast Type Change or hiding some metrics), I lose the percent formatting on the right axes.

I've tried to format in expression: Num(field, '##.#%') and I've also tried to format via Number tab with Format Pattern and Show in Percent checked. Both options work until I dynamically change the chart.

How do I keep the percent formatting?

Is this a QlikView bug?

chart expression, show as percent issue

BarbCline — Wed, 26 Oct 2011 18:58:56 GMT

Anybody have any thoughts?

chart expression, show as percent issue

BarbCline — Tue, 01 Nov 2011 17:26:00 GMT

I promoted this expression to be the first expression in the chart and now all formatting is retained. Crazy guesses pay off!