topic Re: General Acumulate in QlikView

General Acumulate

Mon, 22 Aug 2016 20:57:59 GMT

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???

Re: General Acumulate

hirenjadiya — Mon, 22 Aug 2016 22:35:41 GMT

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.

Re: General Acumulate

Anil_Babu_Samineni — Tue, 23 Aug 2016 03:56:41 GMT

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

Re: General Acumulate

Tue, 23 Aug 2016 14:00:48 GMT

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

Re: General Acumulate

Tue, 23 Aug 2016 16:38:20 GMT

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