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: 
Not applicable

General Acumulate

Hi Everyone,

Actually i need the acumulate of all Historial

Year    Month    Salary

2016      1          1000

2016       2        2000

2015     12         1000

2015     11          3000

When I Chose the Year 2016 and month 2  i need:        

Salary of month 2: 2000 + Salary of Month 1: 1000  +Salary of Month 12: 1000 + Salary of Month 11: 3000

Other Example:

When I Chose the Year 2016 and month 1  i need the Acumulate of:  

Salary of Month 1: 1000  +Salary of Month 12: 1000 + Salary of Month 11: 3000

the acumulate of rest of the months including the last year

Some Any Idea please???

1 Solution

Accepted Solutions
hirenjadiya
Partner - Contributor III
Partner - Contributor III

Hi Omar,

Please find attach the solution.


Other then you Table information I have created 1 extra field "YearMonth" and 1 variable "vYearMonth" which hold the selection value of YearMonth.

Hope it is helpful to you.

View solution in original post

4 Replies
hirenjadiya
Partner - Contributor III
Partner - Contributor III

Hi Omar,

Please find attach the solution.


Other then you Table information I have created 1 extra field "YearMonth" and 1 variable "vYearMonth" which hold the selection value of YearMonth.

Hope it is helpful to you.

Anil_Babu_Samineni

I need to ask you one thing

If you select 2016 .the data should associate only 2016, right?

This scenario why do you require to get 2015 data for 12th and 11th month from 2015

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)
Not applicable
Author

Hi Anil Babu good day,

What i mean is that if  i choose any year for example 2016 i need all information from 2016 and the historial of the rest of the years 2015, 2014, etc,etc.

If i chose 2016 and any month February then i need information from 2016, 2015, 2014 and from months febrary 2016, January 2016, December 2015, November 2015....All Historial

Best Regards

Not applicable
Author

Perfect Really Tahnks God Bless you SOOO muchhhh thanks you make me happy!!! Work it Perfect