topic Re: Summing the latest value for two dimensions in QlikView

Summing the latest value for two dimensions

Wed, 23 Dec 2015 12:18:00 GMT

I'm sure that this is an aggr or set analytics but I can't see it...

With the below data, I need to get latest period balance for each code and then be able to sum that.

Period, Code, Balance

1, 1, 0

2, 1, 100

3, 1, 150

4, 1, 200

5, 1, 00

6, 1, 0

7, 1, 100

8, 1, 0

9, 1, 50

10, 1, 10

11, 1, 500

12, 1, 150

1, 2, 100

2, 2, 150

3, 2, 200

4, 2, 50

5, 2, 10

6, 2, 500

7, 2, 150

8, 2, 0

9, 2, 0

10, 2, 0

11, 2, 0

12, 2, 0

Any thoughts?

sunny_talwar — Wed, 23 Dec 2015 16:10:41 GMT

And you would like to do all of this in the script or the front end of the application?

Wed, 23 Dec 2015 16:12:06 GMT

I need to drill down so this needs to be in the front end

sunny_talwar — Wed, 23 Dec 2015 16:42:04 GMT

Is this what you are looking for? In a text box object?

Wed, 23 Dec 2015 16:54:31 GMT

Afraid not, I need this to be in a pivot table so I can group by Quarter, Year or period - this only works for an overall sum

sunny_talwar — Wed, 23 Dec 2015 17:35:00 GMT

From the data you have shared, would you be able to draw me a picture of your expected output?