Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ncarson3
Contributor III
Contributor III

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 II
Champion II

Frank_Hartmann
Master II
Master II

see attached sample

View solution in original post

ncarson3
Contributor III
Contributor III
Author

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

ncarson3
Contributor III
Contributor III
Author

Very interesting approach, I appreciate the help

ncarson3
Contributor III
Contributor III
Author

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