topic Last 4 months in QlikView

Last 4 months

spividori — Wed, 10 Aug 2011 21:20:11 GMT

Hi.

I have as the Year field dimension and sum (Qty) as expression.

Need in the pivot table "Evolucion de Gastos" show only the last 4 months where sum (Qty) is greater than 0.

Regards.

Wed, 10 Aug 2011 21:47:15 GMT

can u please post the sample qvd

i would like to look at the formula

Thu, 11 Aug 2011 01:33:14 GMT

Hi Sandro ,

Can u clarify one case for me.

u want last 4 months which are in a sequentialorder without zeros or a starting month of last 4 without a zero but not others ?

thanks

Meher

spividori — Thu, 11 Aug 2011 12:27:29 GMT

Hi.

Here attached the file.

I need the chart "Cuadro de Gastos" shows the last 4 months with movement.

In the attached file should show: ago 11, jul 11, jun 11 and may 11.

As shown in the image:

When Sep 11 has as movements should show sep 11, ago 11, jul 11 and jun 11.

Sorry, my English is poor.

Regards

spividori — Mon, 15 Aug 2011 11:44:35 GMT

Hi.

Any suggestions?

Regards.

lironbaram — Mon, 15 Aug 2011 11:48:37 GMT

hei

attach is what you asked for

hope its helps you

spividori — Mon, 15 Aug 2011 13:09:45 GMT

Hi.

Could be, but should appear as selected 4 months, and I need it for other types of graphics.

Regards.

lironbaram — Mon, 15 Aug 2011 13:39:35 GMT

hei

try this