topic Re: How to sum dimension values in Pivot table in QlikView

How to sum dimension values in Pivot table

ashokpaladugula — Sat, 16 Nov 2024 02:50:48 GMT

how can i show total sum of dimension in Pivot table. Please give me some sample.

Thanks,

ASHOK

Re: How to sum dimension values in Pivot table

sunny_talwar — Thu, 01 Aug 2019 17:17:13 GMT

I don't think it is possible without doing some manipulation...

Try this script

RNCTABLE: LOAD * INLINE [ Student, Exam, Points, MaxMarks Student A, Exam 1, 5, 10 Student A, Exam 2, 5, 10 Student A, Exam 3, 5, 10 Student B, Exam 1, 3, 10 Student B, Exam 2, 2, 10 Student B, Exam 3, 5, 10 Student C, Exam 1, 5, 10 Student C, Exam 2, 3, 10 Student C, Exam 3, 3, 10 ]; Dim: LOAD * INLINE [ Dim 1 2 ];

Dimensions

=Pick(Dim, Student, 'Total') =Pick(Dim, MaxMarks, Aggr(Sum(MaxMarks), Student)) ='' Exam

Expression

If(SecondaryDimensionality()=0, Num(Sum(Points)/Sum(TOTAL Points), '0,0%'), Num(Sum(Points), '0'))

Re: How to sum dimension values in Pivot table

ashokpaladugula — Mon, 05 Aug 2019 12:03:08 GMT

Thanks for the reply.

But if i select the filters, it is not working.

Re: How to sum dimension values in Pivot table

sunny_talwar — Mon, 05 Aug 2019 12:12:32 GMT

Which filter? And what is the expected output on selection of the filter?

Re: How to sum dimension values in Pivot table

ashokpaladugula — Mon, 05 Aug 2019 12:18:18 GMT

If i clicked any dimension, sum of dimension is not working fine.

Thanks,

ASHOK

Re: How to sum dimension values in Pivot table

sunny_talwar — Mon, 05 Aug 2019 13:23:32 GMT

Try now

Re: How to sum dimension values in Pivot table

Brett_Bleess — Thu, 22 Aug 2019 20:24:23 GMT

Ashok, did Sunny's final example app work for you? If so, please be sure to use the Accept as Solution button to give him credit for the help and to let others know that the solution worked... If you cannot click the button for some reason, just confirm it was what you needed, and I can mark things for you.

Regards,
Brett