topic Re: Chart format issue in QlikView

Chart format issue

Anonymous — Wed, 13 May 2015 19:31:21 GMT

I'm looking to format the left axis of a line chart as a percent. I've marked all of the expressions as numbers with percent formatting on the Number tab. I've also added num() around all of the expressions to format them as percents. However, the left y-axis still shows as a decimal rather than a percent. The expressions consist of dividing one column by another. Any ideas?

Re: Chart format issue

m_woolf — Thu, 14 May 2015 12:08:16 GMT

Please post a sample qvw showing the problem.

Re: Chart format issue

PrashantSangle — Thu, 14 May 2015 12:13:56 GMT

Hi,

Select relative checkbox from expression tab.

Regards

Re: Chart format issue

buzzy996 — Thu, 14 May 2015 12:18:37 GMT

try tis,

Re: Chart format issue

ToniKautto — Thu, 14 May 2015 12:27:18 GMT

buzzy996‌‌, you might want to get a proper screen grabbing tool to make your images a bit clearer and easier to understand. I use GreenShot, which is a free tool, maybe you want to try it?

Download Greenshot and translations

Re: Chart format issue

buzzy996 — Thu, 14 May 2015 12:29:33 GMT

thanks Toni

Re: Chart format issue

Anonymous — Thu, 14 May 2015 14:46:54 GMT

I tried using the relative checkbox and saw interesting things happen to the number and no percent formatting, and also gave the Fixed formatting a try with no luck. I've attached an example. Thanks!

Re: Chart format issue

m_woolf — Thu, 14 May 2015 14:56:45 GMT

Your expressions ClaimsA, ClaimsO, PremiumA, and PremiumO are causing the axis problem. As soon as I check ClaimA to be displayed as a Line, the axis displays as %.

Re: Chart format issue

Anonymous — Thu, 14 May 2015 15:05:11 GMT

Hi Emily, completing what Mike said, I guess you are hidding the first 4 expressions in the chart because is just a pre-calculation, the chart will use the format of the first expression in the axis, as it is not being plotted it simply goes crazy hehe you just have to add a dummy 0 expression at the beggining with % format, I adjusted your formulas to point to the right columns. See the attached file

Regards,