topic Re: Compare data range II in QlikView

Compare data range II

spividori — Wed, 14 Oct 2015 19:38:13 GMT

Hi.

I am sorry to republish this discussion, but i need can be done with set analysis because the first items not taken the previous 5 values.

In the attached example, I need to calculate for each day of the dimension five days back and compare them with five days previous to the first 5.

For example, for the day 30/09 day should add 30,29,28,27,26 / 09 and compare them with the days 25,24,23,22,21 / 09.

In the example there are more clarification.

Compare date range

Regards.

Re: Compare data range II

sunny_talwar — Wed, 14 Oct 2015 19:41:03 GMT

I don't understand the issue? I though it was doing what you wanted? What is missing still?

Re: Compare data range II

spividori — Wed, 14 Oct 2015 19:53:38 GMT

The problem is that when I apply in my application with the longer period the first values do not take the previous 5.

Regards.

Re: Compare data range II

sunny_talwar — Wed, 14 Oct 2015 20:02:44 GMT

May be a condition on all your expressions:

If(RangeSum(Above(Sum(Imp), 5, 5)) > 0, YourExpression)

Re: Compare data range II

sunny_talwar — Wed, 14 Oct 2015 20:09:32 GMT

Try this instead:

If(Above(Sum (Imp), 9) > 0, yourExpression)

Re: Compare data range II

spividori — Wed, 14 Oct 2015 20:45:48 GMT

I added more data to the example and when I select Sept. it shows data from the 10/09 and I need to show the whole month.

Regards.

Re: Compare data range II

sunny_talwar — Wed, 14 Oct 2015 20:57:23 GMT

See attached:

Re: Compare data range II

spividori — Wed, 14 Oct 2015 21:15:14 GMT

See that there is dates not calculated.

01,08,15,22 y 29.

Regards.

Re: Compare data range II

sunny_talwar — Thu, 15 Oct 2015 07:35:27 GMT

Check this out:

Would a script based solution work for you also?

Re: Compare data range II

sunny_talwar — Thu, 15 Oct 2015 07:57:41 GMT

Try a script like this:

Table:

LOAD Fecha,

Imp,

month(Fecha) as Mes

FROM

RangoFechas.xls

(biff, embedded labels, table is Sheet1$);

FinalTable:

LOAD *,

[5d] - [5d ant] as diff;

LOAD *,

RangeSum(Imp, Peek('Imp'), Peek('Imp', -2), Peek('Imp', -3), Peek('Imp', -4)) as [5d],

RangeSum(Peek('Imp', -5), Peek('Imp', -6), Peek('Imp', -7), Peek('Imp', -8), Peek('Imp', -9)) as [5d ant]

Resident Table

Order By Fecha;

Drop Table Table;

Output in Table box object:

Re: Compare data range II

spividori — Thu, 15 Oct 2015 14:26:53 GMT

Hi.

Great idea! I had not thought solve that way. Thanks.

Regards.