Master and Child can be shown in same column?

[#1]

Hi,

Below is the Table Format, I have

Parent Column	Child Column	Total
ABC	ABC_1	1
ABC	ABC_2	2
BCD	BCD_1	2
BCD	BCD_2	4
BCD	BCD_3	5
CDE	CDE_1	5
CDE	CDE_2	6

I want it to show in Qlikview Report like below:-

Parent Column	Total
ABC	3
BCD	11	(This is total of all childs under BCD group)
BCD_1	2
BCD_2	4
BCD_3	5
CDE	11

Only BCD 's subgroup needs to be shown alongwith the total and that also in same column but with space in the starting

Regards,

Raman

[#2]

Hi,

How cane we approach this type of design? Is this possible in Qlikview?

Regards,

Raman

[trdandamudi]

Please take a look at the attached file and hope this is what you are looking for... Hope this helps...

[trdandamudi]

The second table is exactly what you want. In case if you don't want to see the plus ( + ) sign, then place a text box on the top of the + sign and then you will have exactly what you want. Hope this helps...

[#5]

So basically you have done it using Pivot Chart?

Isn't there any other way to do this type of representation, other than Pivot chart?

Like if I dont want to show that "+" Sign on the report.

[trdandamudi · Accepted solution]

I don't think there is any other way other then Pivot. Let's see if anyone has a better approach on this community, If you don't want to show  '+' sign, then as I said just place a text box over the '+' sign which has the same color as the background and it will be perfect. Hope this helps...