Pivot table problems

MarcoARaymundo — Wed, 16 Oct 2013 20:49:51 GMT

Hi!

I need:

When selecting a date, see the PRODUTOR that did not deliver between the selected date and the day before the earliest date, and delivered in pieces earlier date.

The question is:

How many PRODUTOR did not deliver parts between 10.14.2013 and 10.12.2013, which had delivered parts 10.11.2013?

The rules

In the column of day 2013-10-14 I need count PRODUTOR who delivered parts 11/10/2013.

In columns 10.13.2013 until 10.12.2013, I bring the sum of the parts delivered on each of these dates, which should be zero.

In the column of the day 10.11.2013, I bring the sum of the parts delivered on this date which the PRODUTOR not delivered during the period 10.14.2013 to 10.12.2013.

I tried creating a dimension calculated to see which PRODUTOR that meet the above rules, but it did not work, see.

If(Aggr (Sum ({<MIX_TBL_ORIGEM={'ZLD'}, MIX_PRD_FLAG={'P'}, ANO={'*'}, MÊS={'*'}, MIX_DIA_DO_MES={'*'}, MIX_DTCOLE={'>=$(=Date(a2 - vDiasAnalise))<$(a2)'}>} MIX_QTDTOTAL), FÁBRICA, SETOR, LINHA, MIX_FORNECEDOR_ID) = 0,

MIX_FORNECDOR_ID, Null())

Please, see attached file.

Tks

topic Pivot table problems in QlikView

Pivot table problems