topic Re: customize axes in line chart in QlikView

customize axes in line chart

ali_hijazi — Mon, 30 Jun 2014 07:25:22 GMT

Hello

got a line chart with an expression that is returning close values by dimension

the axes is showing values from 0% till 100% with maximum value of 110%

what I want is show values starting from 60% but stepping 2%

i.e. 60%, 62%, 64%,66%, 68%, 70%, and so on until 110%

I tried the static min = 0.6 and static max 1.1 and static step 0.02

yet it shows a step of 5%

please advise

Re: customize axes in line chart

sasikanth — Mon, 30 Jun 2014 07:57:54 GMT

PFA ,

Re: customize axes in line chart

Mon, 30 Jun 2014 08:04:02 GMT

Hi Ali,

Just add 0.6 to Static Min, this will start the graph at 60%. Add 1.1 to Static Max to limit the graph to 110% and then add 0.02 to Static Step to increment in 2% steps.

Regards,
Marius

Re: customize axes in line chart

sasikanth — Mon, 30 Jun 2014 08:07:30 GMT

Make sure that Log scale is Un Checked

Re: customize axes in line chart

jonathandienst — Mon, 30 Jun 2014 08:11:10 GMT

I suspect that the 2% scale is too small to be rendered properly on the chart, and that QV is upscaling the 2% to 5% to compensate. You could try making the chart (much) larger so that it can display 100 ticks on the vertical axis...

HTH

Jonathan

Re: customize axes in line chart

ali_hijazi — Mon, 30 Jun 2014 11:05:23 GMT

yes the 2% is too small

but this is the requirement!!

the values are very close and I need to show the curve of lines for these small values

Re: customize axes in line chart

ali_hijazi — Mon, 30 Jun 2014 11:05:48 GMT

this is what I did and it is not working

Re: customize axes in line chart

DavidFoster1 — Mon, 30 Jun 2014 11:20:28 GMT

The QlikView chart will not render such a small scale. You will have to look at expanding the chart size to make 2% a reasonable size for QlikView to render or look at something like x-axis scrolling.

Or alternatively write your own javascript chart that does render down to that level of detail.