topic Re: Line chart expression in QlikView

Line chart expression

Tue, 07 Aug 2012 08:10:43 GMT

Hi all,

i'm trying below expression in Line Chart. I,m calculating the Cloverunit = A06129, Lens#=1, measure=Ave Lens Diameter(mm), PLDate = last 2 months sum of LCL.

In pivot table having another few more expressions that displays data from all the dates(Not restricted to last two months).

=Sum({1<[Clover Unit]={'A06129'}, Lens#={'1'},measure={'Ave Lens Diameter (mm)'},PLDate={">$(=Date(AddMonths(Max(PLDate),-2),'MMM DD YYYY'))"}>} LCL)

Now i'm getting line in chart for LCL for last two months , but that value line should display for entire data. Please find the attached screen shot.

Thanks in advance

Regards,

Venkat.

Re: Line chart expression

Tue, 07 Aug 2012 08:33:30 GMT

try to change table to straight and use Acumulation in expression

Re: Line chart expression

Tue, 07 Aug 2012 08:48:11 GMT

Hi,

I'm sorry mistake instead of Line chart i typed pivot table.

Using the expression in line chart.

Thanks in advance.

Regards,

Venkat

Re: Line chart expression

Tue, 07 Aug 2012 08:49:37 GMT

can you post a sample file?

Re: Line chart expression

Tue, 07 Aug 2012 09:07:47 GMT

Hi,

Please find the atached app.

Thanks in advance.

Re: Line chart expression

Tue, 07 Aug 2012 09:30:30 GMT

fist thing is

i see that LCL is similiar to value, so last two monts LCL sum should be about 60*value:)

so chart on your screenshot is wrong

am i right?

Re: Line chart expression

Tue, 07 Aug 2012 09:52:17 GMT

I didn't get what you mean to say ?

Please explain some more briefly.

Thanks in advance

Re: Line chart expression

Tue, 07 Aug 2012 10:02:52 GMT

sum(value)

and

sum(LCL)

are almost equal right?

Re: Line chart expression

Tue, 07 Aug 2012 10:12:18 GMT

Value and LCL are not equal.

But their values will have slight difference i.e; most of the Value field is greater than LCL

What i'm trying to acheive is i'm calculating last 2 months sum(LCL) and that calculated result(i.e;sum(LCL)) should show for all months in line chart.

I hope you might understand now, please let me know if you don't got it. I'll will try to make clear in better way.

Thanks in advance.

Re: Line chart expression

Tue, 07 Aug 2012 10:28:05 GMT

i mean ALMOST EQUAL

this means that sum(LCL) of last two months will be much higher

so the linechart probably look more like:

right?

Re: Line chart expression

Tue, 07 Aug 2012 11:19:25 GMT

Yes,LCL of last two month will be higher.

In the screenshot you shown the LCL is bending down if it is not in between last two months period. Now if it is not in between period then also it should show the straight line instead of bending.

Thanks in advance.

Re: Line chart expression

Wed, 08 Aug 2012 07:52:12 GMT

Hi,

Myself found the solution. Here is the attached app what i tried for.

Regards,

Venkat