topic Re: Different results with Set Analysis in QlikView

Different results with Set Analysis

ecolomer — Sun, 06 Nov 2016 08:59:52 GMT

I have the same formula Set Analysis in two tables and get different results and can not find the cause.

Can you see the image

Attached is a simple data

Re: Different results with Set Analysis

antoniotiman — Sun, 06 Nov 2016 09:53:55 GMT

Hi Enrique,

in Your Set Expression You have

.......... <=$(=Date(FecFin, 'DD/MM/YYYY'))"

FecFin -> 3/11/2016

In First chart there are no limits of Fecha

in the second chart there are limit to 31/10/2016 in dimension

=if([Fecha Operación] >= vFecIni and [Fecha Operación] <= dayend(vFecFin), [Fecha Operación])

So , If You change FecFin to vFecFin You get same results.

Regards,

Antonio

Re: Different results with Set Analysis

ecolomer — Sun, 06 Nov 2016 10:19:43 GMT

Yes, but I need appear only movements between vFecIni and vFecFin

Re: Different results with Set Analysis

maxgro — Sun, 06 Nov 2016 10:48:54 GMT

maybe a missing v?

Sum([Saldo neto]) - Sum({$<[Fecha Operación]={">=$(=Date(vFecIni, 'DD/MM/YYYY')) <=$(=Date(vFecFin, 'DD/MM/YYYY'))"}>} Importe)

Re: Different results with Set Analysis

ecolomer — Sun, 06 Nov 2016 11:07:54 GMT

Hi maxgro‌

No, is correct FecFin.

I've two variables:

- vFecIni is the first date for the interval

- vFecFin is the final date for the interval

- FecFin is the max date in table. In this date I have "Posición" or "Saldo Neto" for this Cuenta.

Posición Inicial = Saldo Neto - Sum(Importe ... from vFecIni to FecFin (both included)

Posición Final = Saldo Neto - Sum((Importe ... from vFecFin (not included) to FecFin (included) or greater than vFecFin

Re: Different results with Set Analysis

Gysbert_Wassenaar — Sun, 06 Nov 2016 14:34:44 GMT

You're using a calculated dimension in the bottom pivot table and you've enabled Suppress When Value is Null for it. That's causing the difference.

Re: Different results with Set Analysis

ecolomer — Sun, 06 Nov 2016 15:35:04 GMT

I Changed calculed dimension, and include selection in expressions.

[Entradas] = if([Fecha Operación]>=vFecIni and [Fecha Operación]<= vFecFin, sum(if(Importe > 0, Importe, 0)))

[Salidas] = if([Fecha Operación]>=vFecIni and [Fecha Operación]<= vFecFin, sum(if(Importe < 0, Importe, 0)))

And results correct.

Thank's for alls

Re: Different results with Set Analysis

Gysbert_Wassenaar — Sun, 06 Nov 2016 15:37:36 GMT

sum(if(Importe > 0, Importe, 0))

You don't need to use an if statement here. Try this instead: sum(RangeMax(0, Importe)). And for the other expression RangeMin instead of RangeMax.

Re: Different results with Set Analysis

ecolomer — Sun, 06 Nov 2016 15:39:20 GMT

Yes you're right