topic Sum with set analysis in QlikView

Sum with set analysis

Wed, 06 Nov 2013 15:16:16 GMT

Hi,

I have the following expression: sum(AVAIL_1)/sum(AVAIL_2)

the result of this expression bring to me the sum of all avails from all weeks, but I need to filter just the avails of the last four weeks (SEMANA)

i wrote the following:

sum({< SEMANA = {'>$(=max(SEMANA) - 4'}>} AVAIL_1)/sum({< SEMANA = {'>$(=max(SEMANA) - 4'}>} AVAIL_2))

but doesn't works.

How can I fixe this?

Thank you!

salto — Wed, 06 Nov 2013 17:09:30 GMT

Hi Rafael,

this works for me:

sum({< SEMANA = {">=$(=(Max(SEMANA) - 4))"}>} AVAIL_1)

sum({< SEMANA = {">=$(=(Max(SEMANA) - 4))"}>} AVAIL_2))

Hope this helps!

javier_florian — Wed, 06 Nov 2013 17:18:01 GMT

You can try with this:

=Sum({<Semana={">=$(=Num(Max(Semana))-2)<=$(=Num(Max(Semana)))"}>} Avail_1)

Sum({<Semana={">=$(=Num(Max(Semana))-2)<=$(=Num(Max(Semana)))"}>} Avail_2)

Regards,

- Javier Florian