Partial Sum on Dimension level

[#1]

Hi Friends,

I am new to Qlikview. And this is my first post

I am stuck with a scenario where i need your help and guidance.

Table1 - Simple pivot Qlikview table with totals

Mapping	Previous	Current	P-C
Jim	123	114	9
John	657	750	-93
Tim	4	6	-2
Jack	65	47	18
Troy	341	303	38
Rick	446	478	-32
Mark	15	13	2
Total	1651	1711	-60

Table 2 - Need to have a partial sum which will have Group 1 and Group 2 totals with Main total at the end.

Mapping	Previous	Current	P-C
Jim	123	114	9
John	657	750	-93
Tim	4	6	-2
Group 1	784	870	-86
Jack	65	47	18
Troy	341	303	38
Rick	446	478	-32
Mark	15	13	2
Group 2	867	841	26
Total	1651	1711	-60

Any help on this would be really appreciated. Thanks!!!

[Gysbert_Wassenaar · Accepted solution]

Create a Group field in the script and use that field as dimension in your pivot table.

GroupMapping:

LOAD * INLINE [

Group, Mapping

Group1, Jim

Group1, John

Group1, Tim

Group2, Jack

Group2, Troy

Group2, Rich

Group2, Mark

];

[sunny_talwar]

Hi Kuldeep,

Welcome to Qlik Community. I hope you will have a lot of fun working with QlikView or Qlik Sense.

I have a question related to your query above. How do you determine which Name goes into which group?

Best,

S

[#4]

Hey S,

Thank you so much.

It was based on the random name selection. The group thing worked fine here.

Regards,

Kuldeep

[#5]

Hey Gysbert,

Thanks for your help. It really worked for me

Regards,

Kuldeep