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: 
suvechha_b
Creator III
Creator III

Total value at the buttom ?

Hi All,

Please kindly assist me how can I get the total value at button ?

clipboard_image_0.png

My requirement -

clipboard_image_1.png

sample model attached.

7 Replies
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi
I think currently you can't get the totals at the bottom in Pivot Table but you can display total at the top by selecting show totals in dimension.
In Straight table, you have the option of displaying totals at Top and bottom.

Thanks
Thanks and Regards
Kashyap.R
tomovangel
Partner - Specialist
Partner - Specialist

Hi, I am attaching the application with Totals at the bottom 😉 

 

Best Regards,

Angel Tomov

mato32188
Specialist
Specialist

Hi Suvechha,

pls find attached image.

 

BR

Martin

ECG line chart is the most important visualization in your life.
RanMH
Contributor III
Contributor III

 Hello, How can i do it for a pivot table ? Thank you.

anat
Master
Master

for pivot table we don't have any option to display Total in bottom.

Hania
Creator
Creator

Hii @suvechha_b ,

you can show totals at top in pivot by enabling the show total tab under your dimension tab.

Thank You.  

Rohan
Specialist
Specialist

Hi @suvechha_b ,

This is possible using Dummy Dimension, Try this :

Dim :

Load * inline [

Dsort

1

2];

Then in your Pivot Table :

Dimension : Pick (Dsort,Claims_band,'Total')

That's it. Then in sorting just change the sorting for your dimension to Sort by expression & use : Pick(Dsort,-(Measure1),5) & sort it as descending. Try this out & let me know if it worked for you. Refer below link, they had a similar use case : 

https://community.qlik.com/t5/New-to-Qlik-Sense/Table-with-max-Min-and-Avg-Value/m-p/2160350#M244116

 

Regards,

Rohan.