topic Re: Line Chart Offset in QlikView

Line Chart Offset

matancha — Tue, 27 Aug 2013 05:16:51 GMT

Hello all.

Is there a way to start a line graph not from 0 (line offset), something like Bar offset but with line?

I'm trying to make a graph for show movements in warehouse (in - out).

My dimention is the time (Yeaar | Month | Date), and the user choose a warehouse.

I'm hold the initial balance in variable called: (vInitBalance), and I want to start the line (Y axis) from (vInitBalance) value, and not from zero.

My problem is that my expression need to be define with "full Accumulation", so i can't define expression like ( $(vInitBalance) + In - Out).

So I looking for a way to doing "line offset".

Thanks in advance for any help -

Matan.

Re: Line Chart Offset

Tue, 27 Aug 2013 05:25:17 GMT

Hi,

Uncheck "Forced 0" under Axes tab from chart properties. And use, Scale to setup your own Static Minimum and Static Maximum with Static Step values for your line offset's.

Re: Line Chart Offset

matancha — Tue, 27 Aug 2013 05:36:19 GMT

HI,

What I need is to showing the right values.

I could not understand how set Min and Max of the Y axis - helps me.

I'm need to move the line (In your proposal the values stay the same).

Tnx -

Matan.

Re: Re: Line Chart Offset

MayilVahanan — Tue, 27 Aug 2013 05:40:54 GMT

PFA - Line chart

Hope that helps

Re: Line Chart Offset

Tue, 27 Aug 2013 05:41:18 GMT

Could you attach your sample application if possible (Or) at leat data from your table?

Re: Line Chart Offset

matancha — Tue, 27 Aug 2013 06:02:58 GMT

I could not understand how your example is supposed to help me. Could you try to explain me?

Matan.

Re: Line Chart Offset

lironbaram — Tue, 27 Aug 2013 06:45:29 GMT

hi attach is an example

Re: Line Chart Offset

whiteline — Tue, 27 Aug 2013 07:07:40 GMT

Hi.

You could just add $(vInitBalance) only for the first dimension value where rowno()=1.

Re: Line Chart Offset

matancha — Tue, 27 Aug 2013 07:40:07 GMT

Thanks you all.

Liron, just because that my dimention is ciclyc dimention the solution of whiteline is better for me. Yours approach is the same.

Tnx again -

Matan.