Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
OLSP
Contributor II
Contributor II

Sub Total of Second Dimension in Column

Hi All!

I am totally stuck with a subtotal for my columns. This is how it looks at the moment:

OLSP_1-1619587955702.png

 

And I would like to add a sub total for Budget/IST, that it looks something like this:

(red highlighting to show what I like to add)

OLSP_2-1619588188018.png

 

Is this even possible - and if yes, how?

Thanks a lot for your help!

Best regards, Oliver

 

4 Replies
MayilVahanan

HI @OLSP 

Try like below 

MayilVahanan_0-1619593702729.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
OLSP
Contributor II
Contributor II
Author

Hi @MayilVahanan 

this only shows the total sum of (Budget PLUS Ist), not seperated by dimension:

OLSP_0-1619593975434.png

 

How can I show seperated sums?

Regards, Oliver

MayilVahanan

Hi,

Then check total in third dimension, its depends on ur requirement.
Or bring additional field, Dim like below url

https://community.qlik.com/t5/QlikView-App-Dev/TOTAL-IN-A-CHART-TABLE-WITH-VALUE-LIST-IN-DIMENSION/m...

Both qlikview and qliksense will work.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
OLSP
Contributor II
Contributor II
Author

Hi @MayilVahanan ,

I am sorry, but I cannot see any connection to what I need.

And I also wasn't able to implement it.

Maybe we just have to leave it as it is.

Thanks anyways for your help!

Oliver