Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

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

Re: General Acumulate

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.

4 Replies
hirenjadiya
Not applicable

Re: General Acumulate

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.

loveisfail
Not applicable

Re: General Acumulate

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

Life is so rich, and we need to respect to the life !!!
Not applicable

Re: General Acumulate

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

Re: General Acumulate

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