topic Re: Subtotal in Straight table in QlikView

Subtotal in Straight table

keerthika — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How to show subtotal and percentage in straight table ?

a	1
a	2
a	3
Total	6
Percentage	23%
b	1
b	2
b	3
b	4
Total	10
Percentage	38%
c	1
c	2
c	3
c	4
Total	10
Percentage	38%

Can any one say how to show the above data in straight table.

Thanks in advance,

Keke

Re: Subtotal in Straight table

jobsonkjoseph — Fri, 02 Nov 2018 09:29:35 GMT

If i'm not wrong, sub totals can be achieved using pivot table not straight table.

Re: Subtotal in Straight table

keerthika — Fri, 02 Nov 2018 09:35:59 GMT

Hi ,

Is there any way to show in straight table

Re: Subtotal in Straight table

jensmunnichs — Fri, 02 Nov 2018 09:43:02 GMT

You can show the subtotals in a pivot table quite easily, but then you wouldn't be able to see all the individual values. If you want to display all values as well, I think you'll have to use a pivot table and give all your rows some sort of unique identifier (otherwise the data will automatically group).

If you don't want to add an identifier, you can do what I did in the attached file and 'hide' the identifier using the dual() function in script.

EDIT: I forgot to enable subtotals in my attached file, just enable 'show partial sums' for [RealID] in the presentation tab in the properties menu for the pivot table.

Re: Subtotal in Straight table

jobsonkjoseph — Fri, 02 Nov 2018 09:50:22 GMT

Ok, try this,

goto properties> Dimention Limits Tab>

here select the dimension you want subtotal for, down below in "options", check "Show Total" and in label type "subtotal".

this might give you the result you are expecting. Other than this there is no way subtotals can be shown in straight table.

Re: Subtotal in Straight table

Frank_Hartmann — Fri, 02 Nov 2018 11:47:03 GMT

is this what you are looking for?

see attached file.

hope this helps