topic Re: Partial Sum on Dimension level in QlikView

Partial Sum on Dimension level

Mon, 02 Mar 2015 12:02:09 GMT

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

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

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

Gysbert_Wassenaar — Mon, 02 Mar 2015 15:11:06 GMT

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 — Mon, 02 Mar 2015 15:15:31 GMT

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,

Tue, 03 Mar 2015 13:49:28 GMT

Hey S,

Thank you so much.

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

Regards,

Kuldeep

Tue, 03 Mar 2015 13:50:37 GMT

Hey Gysbert,

Thanks for your help. It really worked for me

Regards,

Kuldeep