Discussion Board for collaboration on QlikView Scripting.
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
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???
Go to Solution.
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.
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
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
Perfect Really Tahnks God Bless you SOOO muchhhh thanks you make me happy!!! Work it Perfect