topic Re: Do while in QlikView

Do while

upaliwije — Wed, 10 Jul 2019 09:12:10 GMT

Dear Friends

I have developed a QV document with do while loop. But It does not run properly. I have attached the same and kindly help me to correct the syntax.

Re: Do while

upaliwije — Wed, 10 Jul 2019 10:18:28 GMT

Dear Friends,

Kindly help me with a solution

Re: Do while

Frank_Hartmann — Wed, 10 Jul 2019 11:05:41 GMT

please give more information what you are trying to achieve!

Re: Do while

upaliwije — Wed, 10 Jul 2019 11:34:29 GMT

I want my Output table to look like given below with additional column(Y1) being populated with min year of P_From.

POLICY_NO	P_FROM	Y1
00KU1C000748	10/29/2015	2015
00KU1C000748	10/29/2016	2015
00KU1C000748	10/29/2017	2015
00KU1C000748	10/29/2018	2015
00KU1D000662	5/19/2016	2016
00KU1D000662	5/19/2017	2016
00KU1D000662	5/19/2018	2016
00KU1D000662	5/19/2019	2016

Re: Do while

Frank_Hartmann — Wed, 10 Jul 2019 11:42:19 GMT

try this:

sales: LOAD POLICY_NO, P_FROM From TEST.xls (biff, embedded labels, table is Sheet1$) ; left join load POLICY_NO,min(right(P_FROM,4)) as Y1 Resident sales Group by POLICY_NO ;

Re: Do while

upaliwije — Wed, 10 Jul 2019 11:55:56 GMT

Thanks

Is there any possibility of doing the same with do while loop ?

Re: Do while

Frank_Hartmann — Wed, 10 Jul 2019 12:01:21 GMT

i think with a do while loop you cant achieve your desired output!

Re: Do while

Gysbert_Wassenaar — Wed, 10 Jul 2019 12:09:25 GMT

Never use a loop when you can use a join. Loops are very slow compared to operations that work on sets of records instead of on one row at a time.

Re: Do while

upaliwije — Thu, 11 Jul 2019 03:48:36 GMT

Thanks for your valuable advice. I will do it with a join. Still I like to know why my do while does not work. If you can let me have correct script for do while for my knowledge please.