topic Re: Re: Partial sum in Pivot tabel in QlikView

Partial sum in Pivot tabel

Mon, 10 Feb 2014 15:20:28 GMT

Hi,

I have a problem with a pivot table i am trying to set up. I have searched the forums but i cannot seem to find the answer.

I have several persons divided into different groups and age segments. I now want the pivot table to calculate both the partial sums and the total sum of the age groups/person in the columns as expressions. I have tried doing this with dimensionality() function but i cannot seem to get it to work.

Anyone who has an idea?

Cheers,

Re: Partial sum in Pivot tabel

giakoum — Mon, 10 Feb 2014 15:22:34 GMT

does partial sums not work?

Re: Partial sum in Pivot tabel

Mon, 10 Feb 2014 15:25:01 GMT

nope, thank you. thats not what im looking for. i want to be able to see if a persoin has records in a certain age group, and then how many times his records occur in this age group.

Re: Re: Partial sum in Pivot tabel

Mon, 10 Feb 2014 15:29:51 GMT

See the attached file.

Re: Re: Partial sum in Pivot tabel

giakoum — Mon, 10 Feb 2014 15:33:52 GMT

then a bit of set analysis would do it. see attached

Re: Partial sum in Pivot tabel

Mon, 10 Feb 2014 16:05:48 GMT

thank you, this works fine! follow up question though: when i collapse the diagram the entries shows up as a "-" on group level. I would like this to aggregate to a total - do you know how to do that?

Re: Re: Partial sum in Pivot tabel

Mon, 10 Feb 2014 16:48:33 GMT

Hi Add a Supress option when value is null in a dimesnsion tab for all the values..Find the attached file.

Re: Partial sum in Pivot tabel

Wed, 12 Feb 2014 10:24:55 GMT

hi, could you please build from the file posted by Ioannis Giakoumakis (above). i am sorry i cannot get this to fit in to the excisting build