Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
rachita
New Contributor

Looping and sorting

Hi all,

This  1st table is the Data table I have, with master and sub different, in the 2nd table the sub items having SID = MID s of their respective Master items re arranged below them. I want to arrange the sub items below their master items with the help of MIDs. How can I do it?  Urgent.

note- each sub item's SID is equal to its respective master item's MID.

Table1:                                                                                                                                            :

RelationshipMIDSID
Master nil100
Master nil600
Master nil200
sub 1001291
sub 2001292
sub 1001293
Master nil400
sub 6001298

 

Table 2:

RelationshipMIDSID
Master nil100
sub 1001291
sub 1001293
Master nil200
sub 2001292
Master nil400
Master nil600
sub 6001298