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

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

Anonymous — Fri, 29 Sep 2017 04:58:03 GMT

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)
Broccoli	5
Apple	1
Grapes	2
Strawberry	3

And here is what is requested:

	Sum(Quantity)
Vegetables	5
Broccoli	5
Fruit	6
Apple	1
Grapes	2
Strawberry	3

Any help or ideas would be appreciated, Thanks!

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

its_anandrjs — Fri, 29 Sep 2017 05:23:52 GMT

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

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

vinieme12 — Fri, 29 Sep 2017 08:02:00 GMT

or this may be

Partial Sums in straight table | Custom Labels in Pivot SubTotals

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

Frank_Hartmann — Fri, 29 Sep 2017 08:59:07 GMT

see attached sample

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

Anonymous — Sat, 30 Sep 2017 14:49:23 GMT

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

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

Anonymous — Sat, 30 Sep 2017 14:51:36 GMT

Very interesting approach, I appreciate the help

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

Anonymous — Sat, 30 Sep 2017 14:53:23 GMT

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