Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokpaladugula
Contributor III
Contributor III

How to sum dimension values in Pivot table

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

 

Thanks,Untitled.png

ASHOK

 

Labels (3)
6 Replies
sunny_talwar

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'))
ashokpaladugula
Contributor III
Contributor III
Author

Thanks for the reply.

 

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

sunny_talwar

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

ashokpaladugula
Contributor III
Contributor III
Author

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

Thanks,

ASHOK

sunny_talwar

Try now

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.