topic Re: 12 last months in QlikView

12 last months

cristianj23a — Mon, 09 Oct 2017 15:39:22 GMT

Hi.

I have a line graph that shows me the accumulated rotations but I need to show the rotation of the last 12 months.

For example.

If in 2016 you have 4 months of rotation, then you have to show the four months of rotation and the 8 months of rotation of the previous year.

When you do not filter, the rotation of the last 12 months should automatically appear.

Attached my qvw.

Greetings.

Re: 12 last months

sunny_talwar — Mon, 09 Oct 2017 15:57:25 GMT

Does this look like what you wanted?

Re: 12 last months

cristianj23a — Mon, 09 Oct 2017 17:14:37 GMT

Hi Sunny.

I wish that I get an image similar to the one below, with the same values.

For example if I do not make any filter has to appear the rotation until the last month of 2017, in this case October and to the side would be the rest that are November and December of 2016

Attached a new qvw

Greetings.

Re: 12 last months

sunny_talwar — Mon, 09 Oct 2017 17:22:59 GMT

Not sure if I can get the line... but the sorting of the month can be fixed

Re: 12 last months

cristianj23a — Mon, 09 Oct 2017 19:21:05 GMT

That is the order of dates that I will also need after the values come out.

I am using this expression

[Fecha EM]={">=$(=(AddMonths(Max([Fecha EM]),-12)))<=$(=(AddMonths(Max([Fecha EM]),0)))"}

and it filters me but when I add the variable $ (= vTop1RotaciónInsumos) changes the values, I also have to modify that variable so that I get what I require

Re: 12 last months

vikasdesai — Tue, 10 Oct 2017 12:14:58 GMT

Hello Friend

Please use Following Expression,

Sum({<Date={">=$(=Monthstart(max(Date),-11))<=$(=max(Date))"},Year=,Month=>} Sales)

Regards

Vikas