topic Re: Min, Max values in the line chart grid in QlikView

Min, Max values in the line chart grid

Thu, 23 May 2013 13:00:15 GMT

Hello,

I have a problem with showing Min and Max values in the expression Axes.

I have an inline table:

test:

load * inline

[Description, value

'1 - 10', -0.02

'11 - 20', -0.01

'21 - 30', 0

'31 - 40', 0.01

'41 - 50', 0.02

'51 - 60', 1.02]

I filled 0.1 value to the Static step.

Problem in that I need to have -0.02 and 1.02 values on the grid, but i see -0.1 and 1.1.

Is it possible?

Re: Min, Max values in the line chart grid

Gysbert_Wassenaar — Thu, 23 May 2013 13:18:26 GMT

Then you need to set the step size to 0.01 instead of 0.1. You can change that on the Axis tab of the properties window by setting Static Step to 0.01.

Re: Min, Max values in the line chart grid

er_mohit — Thu, 23 May 2013 13:21:05 GMT

Hiii,

your output seems like correct . m not sure where you get wrong answer

try this one in expression

min (TOTAL <Description> value)

and for maximun

max(TOTAL <Description> value)

see the attached file

Re: Min, Max values in the line chart grid

Thu, 23 May 2013 14:28:14 GMT

Hi,

Thanks for the answer, but problem is I need to have -0.02 as Min and 1.02 as Max on grid. Now I have 0.0 and 1.0