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: 
Anonymous
Not applicable

Need help with dimension/field (creating a subtotal value)

Hi y'all, I wanted to see if anyone has any suggestions to create a subtotal value in a dimension for a straight table. It would look almost like a hierarchy.

Here is the Dimension I currently have:

 

Sum(Quantity)
Broccoli5
Apple1
Grapes2
Strawberry3

And here is what is requested:

 

Sum(Quantity)
Vegetables5
  Broccoli5
Fruit6
  Apple1
  Grapes2
  Strawberry3

Any help or ideas would be appreciated, Thanks!

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

see attached sample

View solution in original post

6 Replies
its_anandrjs

You can do this on any of the Straight table by make some changes and it is available to you please read the attched thread for this it is used in financial application.

How to Create a Profit and Loss Statement in QlikView

vinieme12
Champion III
Champion III

or this may be

Partial Sums in straight table | Custom Labels in Pivot SubTotals

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Frank_Hartmann
Master II
Master II

see attached sample

Anonymous
Not applicable
Author

Thanks so much for the link, it looks like a great example.

Anonymous
Not applicable
Author

Very interesting approach, I appreciate the help

Anonymous
Not applicable
Author

Thanks Frank, this is pretty much what I was looking for so I appreciate the support!