Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Question on pivot tables (Total row and additional column)

Hi,

I'm new with QlikSense, I made a pivot table for the scores of each student for three types of exam.  Below is a sample data:

Student/SubjectExam 1Exam 2Exam 3Total% of Overall
Student A55515

15/36 = 41.6%

Student B3251010/36 = 27.8%
Student C5331111/36 = 30.6%
Total13101336

Need some help on the following items:

  1. I can't seem to find any option to put the TOTAL row and column to the end of the table, unlike in straight tables where I'm able to choose where I want the TOTALS to appear
  2. Is there a way to add a column to show the percent of each student's total score to the overall score? When I tried defining a new measure, an additional column appeared for each exam type

Thanks in advance!

1 Solution

Accepted Solutions
Not applicable

Re: Question on pivot tables (Total row and additional column)

Think adding an extension is your best bet - Qlik Sense - Pivot Table Extension

The native pivot table doesn't have totals.

8 Replies
rubenmarin
Not applicable

Re: Question on pivot tables (Total row and additional column)

Hi, you can set the totals up or down in the presentation tab.

There is only one Total by dimension, one trick to add another total row is adding  a dummy dimension, check attachment to see how is done.

Not applicable

Re: Question on pivot tables (Total row and additional column)

Thanks for the info!

However, I can't seem to find the "Presentation" tab in QlikSense.

Will check the attachment

rubenmarin
Not applicable

Re: Question on pivot tables (Total row and additional column)

Ops, sorry, I didn't see it was for Sense, my answer was QlikView based.

Not applicable

Re: Question on pivot tables (Total row and additional column)

Think adding an extension is your best bet - Qlik Sense - Pivot Table Extension

The native pivot table doesn't have totals.

ogster1974
Not applicable

Re: Question on pivot tables (Total row and additional column)

Qlik Sense charts in general are very prescriptive in their setup and application.

Totals for columns appear at the front of the chart because of the responsive environment it works in they thought the total was important and should always be visible to the user if selected regardless of the device they are viewing the chart on.

Totals for rows appear under the row selected for each column.  They do not allow movement of layout for this although in the latest release there is the capability for users to customise charts to certain extent so manipulating the layout.

Regards

Andy

ko12345678
Not applicable

Re: Question on pivot tables (Total row and additional column)

Can someone help me with the below i am trying to add the column total for the last column

TOTALS ON PVOT COLUMN.JPG

rubenmarin
Not applicable

Re: Question on pivot tables (Total row and additional column)

Usually this is because of the expression is calculated by each dimension value, you can try with:

Sum(Aggr(YourExpression, DimensionField))

Creating a new question will help to get answers if this doesn't works.

vishalgoud
Not applicable

Re: Question on pivot tables (Total row and additional column)

Hi Andrew,

Do we have the similar feature in Qlikview, i just want to create an another new column which shows my total for each row..

my requirement in Qlikview is similar like @homar question.

Please let me know thanks much..!!