topic Re: Qlikview Loop Iteration function - ProjectID key in QlikView

Qlikview Loop Iteration function - ProjectID key

idodel — Sat, 16 Nov 2024 01:35:29 GMT

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,

Re: Qlikview Loop Iteration function - ProjectID key

Taoufiq_Zarra — Mon, 06 Jan 2020 12:13:20 GMT

can you share a sample data and the expected output ?

Re: Qlikview Loop Iteration function - ProjectID key

idodel — Mon, 06 Jan 2020 12:56:20 GMT

Ok, hope it will make sense, Table after some left joins:

1- ProjectID	2 - BRI_SUBPROJM (the Leader Project - if exists)	3- BRI_SUBPROJM (the Leader Project of 2 -if exists)	4- BRI_SUBPROJM (the Leader Project of 3- if exists)	Leader2doc (the very first leader - EXPECTED)
PROJ1	PROJ2			PROJ2
PROJ3	PROJ4	PROJ5		PROJ5
PROJ6				PROJ6

Currently: doing the search but not in a loop, and only brings the PROJ5 example.

We will have even more projects connected like 5 in row.

Thanks,

Re: Qlikview Loop Iteration function - ProjectID key

Taoufiq_Zarra — Mon, 06 Jan 2020 13:14:44 GMT

I'm sorry, but I didn't completely understand the objective.

you get the table

1- ProjectID

2 - BRI_SUBPROJM (the Leader Project - if exists)

3- BRI_SUBPROJM

(the Leader Project of 2 -if exists)

4- BRI_SUBPROJM

(the Leader Project of 3- if exists)

and you want to add :

Leader2doc (the very first leader - EXPECTED)

if so what's the rule?

Re: Qlikview Loop Iteration function - ProjectID key

idodel — Mon, 06 Jan 2020 13:31:43 GMT

Hey,

The rule is some kind of loop for every ProjectID:

(BRI_SUBPROJM is the leader of the ProjectID)

while (BRI_SUBPROJM contain value (ProjectID), iterate it.

once the BRI_SUBPROJM contain 0, pull out the very first ProjectID - the leader.

Thanks,

Re: Qlikview Loop Iteration function - ProjectID key

Brett_Bleess — Mon, 06 Jan 2020 16:51:02 GMT

Check out the following Design Blog post, should get you on the right track as far as the finding the row with the empty value part...

https://community.qlik.com/t5/Qlik-Design-Blog/Peek-vs-Previous-When-to-Use-Each/ba-p/1475913

If you want to further search the Design Blog area yourself, use the following URL:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: Qlikview Loop Iteration function - ProjectID key

Brett_Bleess — Mon, 06 Jan 2020 18:51:54 GMT

There are duplicate posts on this thread as well:

https://community.qlik.com/t5/QlikView-Scripting/Qlikview-Loop-Iteration-function-ProjectID/m-p/1662906#M97922

Regards,
Brett

Re: Qlikview Loop Iteration function - ProjectID key

idodel — Wed, 08 Jan 2020 10:13:05 GMT

Hey, checked it out, and not quiet understand how am I able doing that in a loop as well.

please try to describe how is that going.

Thank you

Re: Qlikview Loop Iteration function - ProjectID key

idodel — Wed, 08 Jan 2020 11:06:02 GMT

https://community.qlik.com/t5/New-to-QlikView/Looking-at-previous-rows-until-a-specific-value-is-found/m-p/1253674

This post is dealing with something that reminding my issue, but not including a loop search.

Can someone share how I is that going in the script ?

Best Regards,

Ido

Re: Qlikview Loop Iteration function - ProjectID key

idodel — Tue, 14 Jan 2020 13:57:05 GMT

Any suggestions for the issue?

Thanks

Re: Qlikview Loop Iteration function - ProjectID key

Brett_Bleess — Tue, 21 Jan 2020 19:49:14 GMT

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