topic Re: Acumulate in object in QlikView

Acumulate in object

fkeuroglian — Tue, 24 Nov 2015 20:20:28 GMT

Hi Expert i want to create a table that acumulate values, not only show the each value, instead of this sum the previuos month

not show only the value of the month, show the acumulate of every year

i attached an image that i have now, and the qvw and qvd for example

thank you a lot

Fernando K.

I HAVE THIS NOW:

06-2014 10

07-2014 15

08-2014 0

09-2014 5

i want this:

06-2014 10

07-2014 25

08-2014 25

09-2014 30

Re: Acumulate in object

sunny_talwar — Tue, 24 Nov 2015 20:26:59 GMT

Like these:

Or do you want the value to reset each year?

Re: Acumulate in object

Mark_Little — Tue, 24 Nov 2015 20:35:28 GMT

Hi,

Take a look at the below

Peek() or Previous() ?‌

I use them a lot for things like this.

Mark

Re: Acumulate in object

fkeuroglian — Tue, 24 Nov 2015 20:36:45 GMT

Excelent Sunny!

This is was i looking, There is a possibility to add information if there is no registry for the month that Doesnt have any contract?

for example if you select 2015 only show 08-2015 09-2015 and 10-2015 , is the possibility to show the 12 month of the year instead have or not have record?

thank you sunny for all your help always helpfully!

Fernando K.

Re: Acumulate in object

sunny_talwar — Tue, 24 Nov 2015 20:50:07 GMT

So just trying to understand -> Are you looking to get other months were there is not values?

Re: Acumulate in object

fkeuroglian — Tue, 24 Nov 2015 20:53:52 GMT

Yes Sunny

for example if i have this for the year 2015

08-2015 2

09-2015 3

10-2015 8

i want to see this:

01-2015 0

02-2015 0

03-2015 0

04-2015 0

05-2015 0

06-2015 0

07-2015 0

08-2015 2

09-2015 3

10-2015 8

11-2015 8

12-2015 8

Thank you Sunny!

Re: Acumulate in object

sunny_talwar — Tue, 24 Nov 2015 20:56:59 GMT

Does this need to be a pivot table? or straight table will also work? If straight table is okay, you can add another column (I did =Año) and hide the column from Presentation tab and then you will see all the 12 months.

Re: Acumulate in object

fkeuroglian — Tue, 24 Nov 2015 21:16:44 GMT

Sunny, in a simple table as you do it works great, but if i pass to a bar chart do not work

is there any way to do using a chart?

thank you a lot!

Fernando

Re: Acumulate in object

sunny_talwar — Tue, 24 Nov 2015 21:21:28 GMT

This?

Re: Acumulate in object

fkeuroglian — Tue, 24 Nov 2015 21:23:46 GMT

Thank you Sunny!

perfect

Fernando K.

Re: Acumulate in object

sunny_talwar — Tue, 24 Nov 2015 21:25:03 GMT

Awesome