Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

sum selected and some unselected

Hi!

I have simple table with fields:

CountrymonthSale
England20120114 625
England20120218 733
England20120324 169
England20120422 171
England20120522 586
England20120625 032
England20120728 343
England20120824 971
England20120925 826
England20121024 560
England20121115 207

and i want add object like this:

CountrymonthSale
England201211= sum of last 3 month

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

is anybody know what i missed?

Tags (2)
4 Replies
jagannalla
Valued Contributor III

Re: sum selected and some unselected

Hello,

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

Not applicable

Re: sum selected and some unselected

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:

CountrymonthSum (Sale)3month
England20120114625201110
England20120218733201111
England20120324169201112
England20120422171201201
England20120522586201202
England20120625032201203
England20120728343201204
England20120824971201205
England20120925826201206
England20121024560201207
England20121115207201208

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

MVP & Luminary
MVP & Luminary

Re: sum selected and some unselected

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


talk is cheap, supply exceeds demand
Not applicable

Re: sum selected and some unselected

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

Community Browser