topic Re: parent child relation in QlikView

parent child relation

Tue, 29 Jul 2014 12:26:14 GMT

HI All,

I have a issue,please see the below table:

parent	child	person	subperson	sales
1	-	a	-	10
2	22	b	c	10
2	23	b	b	20
2	24	b	b	30
3	33	d	e	40
4	-	f	-	40
5	55	c	d	20
5	56	c	c	25
5	57	c	e	35
6	66	f	f	55
6	67	f	b	50
6	68	f	a	40

I have the data based on parent child relation and i have person and subperson based on the parent child relation sample data is the above one.

My requirement is

1.Now i want to display person and subperson as a single field.

2.If i will select any person it should show the value of that person only ex:if i will select b value is 100,c=35,a=50.

3.If i will select parent it should show that parent sales ex:2=60,4=40,5=80,6=145.

can some one help me on this...

thanks in advance,

regards,

baru

Re: parent child relation

Wed, 30 Jul 2014 05:53:19 GMT

HI All,

I have a issue,please see the below table:

parent	child	person	subperson	sales
1	-	a	-	10
2	22	b	c	10
2	23	b	b	20
2	24	b	b	30
3	33	d	e	40
4	-	f	-	40
5	55	c	d	20
5	56	c	c	25
5	57	c	e	35
6	66	f	f	55
6	67	f	b	50
6	68	f	a	40

I have the data based on parent child relation and i have person and subperson based on the parent child relation sample data is the above one.

My requirement is

1.Now i want to display person and subperson as a single field.

2.If i will select any person it should show the value of that person only ex:if i will select b value is 100,c=35,a=50.

3.If i will select parent it should show that parent sales ex:2=60,4=40,5=80,6=145.

can some one help me on this...

thanks in advance,

regards,

baru

Re: parent child relation

Wed, 30 Jul 2014 09:03:59 GMT

can any help in this...

Re: parent child relation

Wed, 30 Jul 2014 12:28:50 GMT

Hi,

can anyone know how to resolve this......

Re: parent child relation

michael_maeuser — Wed, 30 Jul 2014 12:35:45 GMT

1. just load person & subperson as field...

2, 3. qlikview does that usually always, if you do a sum(sales)

Re: parent child relation

MarcoWedel — Sat, 23 Aug 2014 12:55:38 GMT

Hi,

like this?:

tabSales:
LOAD parent,
    child,
    person,
    subperson,
    sales
FROM [http://community.qlik.com/thread/127519]
(html, codepage is 1252, embedded labels, table is @2);

hope this helps

regards

Marco