Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Totals In Pivot Table with Measures as Rows

Hi All I have the below Pivot Table which has measures as the rows.  Is it possible to get totals for each measure?

pivottable.png

1 Solution

Accepted Solutions
Highlighted

Oh got it... may be add a island table in the script like this

Dim:

LOAD * INLINE [

Dim

1

2

];

and then change your Company dimension to this

Pick(Dim, Company, 'Total')

View solution in original post

6 Replies
Highlighted

So, NAV, Total Debt, Cash.... etc are values within a field? and you would like to add Total Sources and Total Uses as extra values?

Highlighted
Creator III
Creator III

Ah sorry ignore the coloring.  Each row is a different measure/expression and I would like to show totals for each measure across all companies.  So ideally there would be a totals column which shows the totals for each measure. i.e total nav = Company 1 NAV + Company 2 NAV + Company 3 NAV Etc

Highlighted

Oh got it... may be add a island table in the script like this

Dim:

LOAD * INLINE [

Dim

1

2

];

and then change your Company dimension to this

Pick(Dim, Company, 'Total')

View solution in original post

Highlighted
Creator III
Creator III

Awesome thanks!

Highlighted
Creator III
Creator III

One more question.  My total responds to selections made, ie if I select company 1 the total column will show the same values as just company one.  Do you have an idea on how to have the total column show values for the whole data set.

Highlighted

May be try this expression

Pick(Dim,

Sum(Measure),

Sum({1} Measure))