Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Add values from the previous year to the following

Hello,

I am new to QlikSense. I have a table for which I have to count certain occurences for each year. Until that point it is fine. I am having trouble in adding the results from the previous year to the following year and so on... I saw an example here but I would only get results for the max year and the one before it (https://community.qlikview.com/thread/174599‌). Can you help me on how to achieve this?

Best regards,

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Thank you all for your kind suggestions. Eventually I found a solution for my problem.

The suggestion from Stefan Wühl on the following thread worked perfectly for my data: Cumulative sum | Qlik Community

View solution in original post

5 Replies
mdmukramali
Specialist III
Specialist III

Hi Filipe,

Can you attach Sample file.

for that we can help you in better way,

Thanks,

Mukram.

pradosh_thakur
Master II
Master II

I Guess you are talking about cumulative sum . one thread as such is this  . check out the responses in this thread  https://community.qlik.com/thread/286279


regards

Pradosh

Learning never stops.
OmarBenSalem

do u have date field? Month etc?

if so,

do sthing as follow:

count({<date=,Year=,Month=,Quarter=, date={"<=$(=Max(date))"}>}YourMeasure)


Anil_Babu_Samineni

You have to declare variables as in From and To. And, Then you could re-attempt using set expression

Sum({<Field = {">=$(=AddMonths(Max(Field), -1)) <=$(=Max(Field))"}>} Measure)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Thank you all for your kind suggestions. Eventually I found a solution for my problem.

The suggestion from Stefan Wühl on the following thread worked perfectly for my data: Cumulative sum | Qlik Community