topic Re: Master and Child can be shown in same column? in QlikView

Master and Child can be shown in same column?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Master and Child can be shown in same column?

Thu, 08 Dec 2016 11:10:54 GMT

Hi,

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

Regards,

Raman

Re: Master and Child can be shown in same column?

trdandamudi — Thu, 08 Dec 2016 14:23:12 GMT

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

Re: Master and Child can be shown in same column?

trdandamudi — Thu, 08 Dec 2016 15:05:04 GMT

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...

Re: Master and Child can be shown in same column?

Fri, 09 Dec 2016 10:52:01 GMT

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.

Re: Master and Child can be shown in same column?

trdandamudi — Fri, 09 Dec 2016 11:41:28 GMT

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...