topic Set Analysis help. in QlikView

Set Analysis help.

spividori — Wed, 30 Oct 2013 20:40:50 GMT

Hi.

In my example I have a pivot table with fixed AñoMes in the last four months.

I need to select a value in the Line field and display only the values of this selection within 4 months.

Regards.

spividori — Thu, 31 Oct 2013 11:30:00 GMT

Someone could help me?. Thanks.

Thu, 31 Oct 2013 11:36:38 GMT

Hi Sandro,

You sould use $ and not 1

Sum({ $ <AñoMes={">$(=Date(AddMonths(Max({1}AñoMes),-4),'MMM YY'))"}>} Cantidad)

spividori — Thu, 31 Oct 2013 12:45:22 GMT

Hi Jairo.

Thanks for responding.

I need that the period to be static or fixed .

Regards.

ronaldocarrijo — Thu, 31 Oct 2013 12:52:36 GMT

Try This:

spividori — Thu, 31 Oct 2013 15:43:25 GMT

Hi Ronaldo.

It is excellent!, Just what I need, works perfect. Thank you very much.

Regards.