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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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