topic Set analysis - Calculating using a expression on the same pivot table in QlikView

Set analysis - Calculating using a expression on the same pivot table

AitorK — Thu, 17 Jan 2019 16:42:44 GMT

Hi,

I have a pivot table with a expression that uses a variable (__PeriodoATCBaja) for calculating a sum:

= Sum ({$<[PeriodoHasta]={$(__PeriodoATCBaja)}>} [AtCompletion_Baja])

But instead of using this variable (which has a single value for all the pivot table) i want to calculate the sum based in the next expression which i have already added in the pivot table:

= aggr(MAX({< [AtCompletion_Baja] = {'>0'} >} [PeriodoMovto]), [Oferta])

(This expreson label is FechaBajaOfer]

The purpose is to make the sum for each row according to the expression value in FechaBajaOfer.

I try the expression below but it always returns 0:

=Sum({$<[PeriodoHasta]=FechaBajaOfer>}[AtCompletion_Baja])

If I use the variable for the expresion the result is:

Thanks in advance

Re: Set analysis - Calculating using a expression on the same pivot table

sunny_talwar — Thu, 17 Jan 2019 16:50:03 GMT

Try this

Sum(Aggr(
If([PeriodoHasta] = Max(TOTAL <Oferta> {<[AtCompletion_Baja] = {'>0'}>} [PeriodoMovto]), [AtCompletion_Baja])
, [Oferta], [PeriodoHasta]))

Re: Set analysis - Calculating using a expression on the same pivot table

AitorK — Fri, 18 Jan 2019 07:45:22 GMT

Thanks for your reply, but it is returning 0 value.

Re: Set analysis - Calculating using a expression on the same pivot table

sunny_talwar — Fri, 18 Jan 2019 12:24:47 GMT

Would you be able to share a sample to show the issue?