topic Re: sum selected and some unselected in QlikView

sum selected and some unselected

Wed, 28 Nov 2012 12:28:04 GMT

Hi!

I have simple table with fields:

and i want add object like this:

Country	month	Sale
England	201211	= sum of last 3 month

problem is - when i select 201211 another monthes just disappear from my sum.

is anybody know what i missed?

jagannalla — Wed, 28 Nov 2012 12:33:28 GMT

Hello,

Change your expression to =Sum({<Month =, here the set analysis what you develped to get last 3 months>}Sales)

Wed, 28 Nov 2012 13:21:59 GMT

Hi, Jagan Nalla!

Im only in step - getting month that = moth-3

if(Right(month,2)>3,month - 3,left(month,4)-1&12+(Right(month,2) - 3))

(please sea attachment)

i have:

exemp. last row: my month is 201211 and 3month ago is 201208

and now i need formula, that sum all sales between 201208 and 201211

in spite of: selected those data or not

Gysbert_Wassenaar — Wed, 28 Nov 2012 13:48:10 GMT

You can do this by joining every month with the months of its three month period and sales for those months. See attached example.

Fri, 30 Nov 2012 07:41:29 GMT

Hi, Gysbert!

Thank you for your help!

How can i do this joining? Only when i load data?

incoming data sourse has more than 900 000 rows