Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhishek1
Contributor III
Contributor III

Totals in Pivot table

hi,

I am developing a dashboard in which a Pivot chart needs to show Totals. The Chart shows the count of Projects and the annual revenue by Phase and by month. We are showing this data for the latest two months Separately in chart. Please see the attached image for better understanding. 

The issue is The users want the Totals to show separately for every month in the end. just like the period is divided in every phase.

can anyone help?

1 Solution

Accepted Solutions
sunny_talwar

Try like this... create an island table in the script like this

LOAD * INLINE [
Dim
1
2
];

and then change Phase dimension to this
Pick(Dim, Phase, 'Total')

Sort order for this new dimension will use sort by expression
Only({1} Dim)*10000000 + any other sorting expression you have

View solution in original post

8 Replies
sunny_talwar

Did you try to add the partial sum for Period?

Abhishek1
Contributor III
Contributor III
Author

Hi Sunny,

Yes I did. It shows partial sum for every Phase separately. I dont want to show it like that. I want to show the Total in the end to show totals separately for each month.  Please find the images of the output after applying partial sum and what I am trying to achieve. Please see the Total section of the Desired_Output image.

 

sunny_talwar

Try like this... create an island table in the script like this

LOAD * INLINE [
Dim
1
2
];

and then change Phase dimension to this
Pick(Dim, Phase, 'Total')

Sort order for this new dimension will use sort by expression
Only({1} Dim)*10000000 + any other sorting expression you have

Abhishek1
Contributor III
Contributor III
Author

hi,

 

I understood that I have to create a data island named Dim. I am not clear what I have to do next. can you please explain a bit. sorry I am new here.

Thanks,

Abhishek

 

Abhishek1
Contributor III
Contributor III
Author

hi Sunny,

I understood that I have to create a data island named Dim. I am not clear what I have to do next. can you please explain a bit. sorry I am new here.

Thanks

sunny_talwar

Are you able to share a sample where you trying to do this? It might be easier for you to see it implemented

jaibau1993
Partner - Creator III
Partner - Creator III

Hi both!

I made a simplified example to ilustrate Sunny's solution (it is fanstastic, by the way, so clever).

Please see the attached file, maybe it helps you understand Sunny.

Jaime

Abhishek1
Contributor III
Contributor III
Author

Brilliant, Thanks Very much.