topic Re: Many to Many relationship in QlikView

Many to Many relationship

markgraham123 — Tue, 28 Jul 2015 17:31:02 GMT

Hi,

I have the below data.

When i try to get data in table like,

W2 SUm(Qty)

i get error data when i drill down to SKU....It doesn't show individual SUm() but shows Total() as result in every field...

Can anyone help me

SKU W1 Qty

1 a 234

2 b 4323

1 c 32

2 d 12

SKU W2 Location

1 a 22

2 b 324

1 c 4545

2 d 231

Re: Many to Many relationship

MK_QSL — Tue, 28 Jul 2015 17:48:53 GMT

Not clear from you description. Can you provide some more information... possibly what result you are looking for when you select any SKU?

Re: Many to Many relationship

Kushal_Chawda — Tue, 28 Jul 2015 17:51:24 GMT

try like this

LOAD *,SKU&W1 as Key Inline [

SKU , W1, Qty

1, a, 234

2, b, 4323

1, c, 32

2 , d, 12 ];

LOAD *,SKU1&W2 as Key Inline [

SKU1, W2 , Location

1, a , 22

2, b, 324

1, c, 4545

2, d, 231

Re: Many to Many relationship

markgraham123 — Tue, 28 Jul 2015 18:08:06 GMT

Hi,

But in my original application,

SKUK1&W2 is not unique.

Re: Many to Many relationship

markgraham123 — Tue, 28 Jul 2015 18:12:00 GMT

Hi Manish,

When i select SKU it should show the respective Sum...for the warehouse and sku.

But it shows the overall total sum.

Please have a look at the application i posted.

Re: Many to Many relationship

Kushal_Chawda — Tue, 28 Jul 2015 18:14:07 GMT

Then you need to find the columns(Combination of columns) which uniquely identifies the Row in both the table.

Re: Many to Many relationship

markgraham123 — Tue, 28 Jul 2015 18:20:59 GMT

THanq Kush..

I'm working on that

Re: Many to Many relationship

markgraham123 — Tue, 28 Jul 2015 18:28:14 GMT

Hi Kush,

I have thousands of rows after the combination of unique collumns,

Is there nay technique to check whether its unique or not...other than using frequency??

Re: Many to Many relationship

Kushal_Chawda — Tue, 28 Jul 2015 18:36:38 GMT

Suppose I have created the Key with combination of fields (A+B+C), so Count of key (Count(key)) should match with number of rows.

Re: Many to Many relationship

markgraham123 — Tue, 28 Jul 2015 18:40:48 GMT

hi Kush,

Sorry for too many questions...

Count(Key) should match with number of rows????

number of rows of what???

cna u pls lemme knw

Re: Many to Many relationship

Kushal_Chawda — Tue, 28 Jul 2015 18:46:19 GMT

Total number of rows means "Number of rows in your table in which you have created key"

for example

Tab1:

load * inline [

Field

2 ];

Here number of rows =2 and also Count(Field)=2 i.e Field is Primary key

Hope it is clear now