Qlikview Loop Iteration function - ProjectID key

[idodel]

Hello Qliks! 

I have a Projects table that contain ProjectID field & might have a another project who leads the same Project above the first.

exists: -left joins the DOC for checking, not in infinite way. 

left Join
LOAD
DOC as Leader1doc ,
If(BRI_SUBPROJM<>0,BRI_SUBPROJM,DOC) as Leader2doc
FROM [Data\DOCPROJ.qvd] (qvd);

demand: Building a loop iteration that pulls out the very first ProjectID that doesn't contain any leader.

Any suggestions? 

BRI_SUBPROJM<>0 - checking if the ProjectID has any leader.

Thanks,

[Brett_Bleess]

Only thing I could suggest is if you can attach a QVW etc. that will let folks see more details, the data model etc., as that is generally very helpful in these cases when folks have full access to be able to see everything.  Does not have to be your official app, could just be another sample app that creates the same condition etc.  If you are just worried about a few fields of data, you can use the Scramble feature in the Desktop Client to scramble any fields that have info you do not really want folks to see, that is in Settings\Document Properties\Scrambling tab...  Sorry I do not have anything better for you.

Regards,
Brett