topic Data scenario in QlikView

Data scenario

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

Hi All

I have a data like below.

There is a start point and end point. eg I can go from A to B, or E to F.

But I can reach from A to B via C as well.

I want to know all the possible combinations between two points.

eg A to B can be reached by two ways .

1. directly from A to B

2. A to C then C to B.

Start End

A B

E F

A C

C B

Please help.

Thanks

vinieme12 — Tue, 20 Dec 2016 09:49:02 GMT

try

MAIN:

LOAD * INLINE [

Start,End

A,B

E,F

A,C

C,B

];

Left JOIN(MAIN)

LOAD Start as End

,End as End2

RESIDENT MAIN;

How many levels to do you have?

Anil_Babu_Samineni — Tue, 20 Dec 2016 09:55:37 GMT

What was the Expected output to see on UI?