grouping - Sub Totals in table diagram

[#1]

Hello all,

I know this is often discussed theme, but I haven't found a real solution for it.

I want to group the item groups by value (all item groups starting with 1, group 1, all starting with 2 in group2....)

Every new group should display the sub total (please see picture below)

ITEM GROUP ID | Price here the current table

1245 | 2,45

1451 | 2,87

2457 | 2,45

2475 | 2,78

ITEM GROUP ID | Price this is my dream to be displayed in qlikview

1245 | 2,45

1451 | 2,87

Subtotals Group 1 5, 32

2457 | 2,45

2475 | 2,78

Subtotals Group 2 5, 23

I have tried my best, but this wasn't enough. I hope someone can help me.

Regards

[#2]

Hi,

see the attached example.

Good luck!

Rainer

[#3 · Accepted solution]

Hello Rainer,

this looks very simple, but it is great.

thank you very much.

[#4]

HI,

Instead of having a calculated dimension you can generate the field in script while loading from qvd/database.

left(ItemGroupID,1) as Group

then you can directly use Group in your dimension.

Calculated dimensions will gradually effect the performance of the qlikview application.

Thanks & Best Regards,

Kuldeep Tak

[#5]

Hi,

thank you, this is also a very good idea. No, I have the choice and I learn every day more.

Thanks for all the help.

Regards Christoph