How to read parent child data hierarchy

Fri, 18 Oct 2013 12:15:45 GMT

Hi ,

I am new to Qlikview & we have below requirement

Circuit :

Cktid Name CktType

100 abc M

101 abcd M

102 ah H

103 gh L

104 jkkl LP

CircuitCircuit: ( One Child may have more then one parents & One parent may have more then two childs )

These Hierarchy is not fixed , Depends on services the circuit hierarchies changes

ParentCktid ChildCktid

100 102

101 102

100 103

103 104

Service: ( Service can be associated with any child circuit )

serviceid Circuitid

S1 102

S2 103

S3 104

Requirement is we need to find the dependency Services for each circuit.

Expected out put :

Cktid Serviceid

102 S1

103 S2

104 S3

101 S1

100 S2

100 S3

In Pl SQL written while loop inside functions & functions are called from SQl stmt, But customer requirement is need to execute this business logic from Qlikview ( We don't have option to user SQL statement from Qlikview bcz of performance impact ).

I check the option to write macro - using Vbscript but we have to use the .Qvd file.

Any option to get this functionality ?

Re: How to read parent child data hierarchy

Gysbert_Wassenaar — Fri, 18 Oct 2013 15:21:14 GMT

See attached example.

Re: How to read parent child data hierarchy

Mon, 11 Nov 2013 04:14:14 GMT

Hi Gysbert..

It's working now but we have to execute this hierarchybelongsto function on 5 Million records.

Any performance impact on this function?

Thanks

Rajesh

topic Re: How to read parent child data hierarchy in QlikView

How to read parent child data hierarchy

Re: How to read parent child data hierarchy

Re: How to read parent child data hierarchy