topic Re: Totals for Valuelist in QlikView

Totals for Valuelist

saimahasan — Sat, 09 Jun 2018 08:55:32 GMT

Hi,

I have a problem with the valuelist used in pivot chart.

Problem statement: I have 4 dimensions (valuelist(),Fund Name, SFIN, valuelist())

Now i want the totals at the first valuelist dimension level taking the summation for the last valuelist dimension

For eg:

I want to display the last column (Total which takes the total at "Current Yr" & "Previous Yr" level)

Any help would be appreciated.

Anil_Babu_Samineni — Sat, 09 Jun 2018 13:21:04 GMT

Can you please provide sample

saimahasan — Tue, 12 Jun 2018 04:03:29 GMT

Hi,

PFA of the sample data and the application. I would like to show the totals at the end of the chart for 'Current Year' & 'Previous Year'.

Kindly suggest the solution.

saimahasan — Tue, 12 Jun 2018 06:54:57 GMT

please suggest..

sunny_talwar — Tue, 12 Jun 2018 09:12:40 GMT

This?

saimahasan — Tue, 12 Jun 2018 09:17:40 GMT

Attaching the files again.

sunny_talwar — Tue, 12 Jun 2018 11:53:21 GMT

What do you want me to do with them?

saimahasan — Wed, 13 Jun 2018 03:58:37 GMT

If you look at my initial post i have mentioned the problem statement.

I want the totals at the valuelist dimension level but not able to achieve...

Can you suggest any solution??

sunny_talwar — Wed, 13 Jun 2018 09:00:20 GMT

What was wrong with my response here? Re: Totals for Valuelist

Did this not work?

saimahasan — Thu, 14 Jun 2018 10:16:13 GMT

It worked. Thanks a lot.