Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BarbCline
Contributor III
Contributor III

chart expression, show as percent issue

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?

1 Solution

Accepted Solutions
BarbCline
Contributor III
Contributor III
Author

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

View solution in original post

2 Replies
BarbCline
Contributor III
Contributor III
Author

Anybody have any thoughts?

BarbCline
Contributor III
Contributor III
Author

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