topic declaring variables in sum expresion in QlikView

declaring variables in sum expresion

Wed, 19 Jan 2011 09:17:57 GMT

Hi everybody!!

I´m trying to do a pivot table report with that condition:

SUM

({$<MONTH={$(=MONTH)}>} IF(DIARIO='BSS' AND DH='H' AND MONTH>0,IMP_DIARIO,0))

My problem is that if I select one month (for example 2) I want to sum values from 1 to 2; If I select month 5, I want to sum values from 1 to 5. I tried to write SUM({$<MONTH<=... but it doesn´t work.

Any help? Thanks for your answers

Fiber9906

declaring variables in sum expresion

sparur — Wed, 19 Jan 2011 09:24:13 GMT

Hello, Fiber.

try this:

SUM({$<MONTH={">0<=$(=vMONTH)"}, DIARIO={'BSS'}, DH={'H'} >} IMP_DIARIO)

declaring variables in sum expresion

Wed, 19 Jan 2011 09:35:54 GMT

Thanks for your help!! It works ok!

Fiber9906