topic Re: Intersection between two values in QlikView

Intersection between two values

nisha_rai — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want those data set which is common between two values.Please help me to resolve the issue.

for example;

filed1 Contain A and B value

Filed2 contain C, D,E,F,G,H,I,J etc

C,D,E is common value for A and B

I want to create a Table which is giving me the common value of filed1

Expected Reult:

Filed1 Field2

A C

A D

A E

Thanks

Re: Intersection between two values

sushil353 — Tue, 07 Mar 2017 06:44:38 GMT

Hi,

What is the expected output?

Re: Intersection between two values

Anil_Babu_Samineni — Tue, 07 Mar 2017 06:45:55 GMT

Where Exists() can help you

Re: Intersection between two values

PrashantSangle — Tue, 07 Mar 2017 06:47:39 GMT

Hi,

Can you provide proper data with required output in excel..

Regards,

Prashant

Re: Intersection between two values

nisha_rai — Tue, 07 Mar 2017 06:53:15 GMT

Hi,

Field1 Field2

A C

A D

A E

A F

A G

B C

B D

B E

B I

B J

Expected Output

Field1 Filed2

A C

B C

A D

B D

A E

B E

A F

A G

Re: Intersection between two values

ahaahaaha — Tue, 07 Mar 2017 07:36:23 GMT

Hi Nisha,

May be like this

Table1:

LOAD*Inline

[Field1, Field2

A, C

A, D

A, E

A, F

A, G

B, C

B, D

B, E

B, I

B, J];

NoConcatenate

Table2:

LOAD*

Resident Table1

Where Field1 = 'A' Or (Field1 = 'B' And Previous(Field1) = 'A' And Field2 = Previous(Field2))

Order By Field2, Field1;

DROP Table Table1;

Result

Regards,

Andrey

Re: Intersection between two values

sasiparupudi1 — Tue, 07 Mar 2017 08:35:15 GMT

May be Try

T1:

Load

AutoNumber(Field2) as Key;

Load * Inline

[

Field1,Field2

A,C

A,D

A,E

A,F

A,G

B, C

B, D

B, E

B, I

B, J

];

T2:

NoConcatenate Load

Field1,Field2,Key,

If(Key=Peek(Key),1,0) as Flag

Resident T1

Order by Key;

Inner Join(T2)

Load

Distinct Key

Resident T2

Where Flag=1;

Drop Table T1;

Re: Intersection between two values

nisha_rai — Tue, 07 Mar 2017 09:03:36 GMT

Thanks Andrey,

Based on the result i want to apply section access on that.

For example:

User X belong to A, can able to see the all the data of Field 2 which belong to A but for B he can able to see only the common data. means

User X can able to see the below data

Field1 Field2

A C

A D

A E

A F

A G

B C

B D

B E

Regards,

Nisha