topic Re: recursive field value in QlikView

recursive field value

felcar2013 — Fri, 19 Apr 2013 13:02:29 GMT

i want to create a new column in my customer table, where i want to estimate a the column values based on the following rule:

the new field shall show the activity level of the previous period as shown in the table. do you know if it is possible to get the new column in the same customer table?

Customer	Active	Period ID (timestamp)	New Field (Active previous period)
00001	Yes	149	-
00001	Yes	150	Yes
00001	No	151	Yes
00001	No	152	No
00001	Yes	153	No

Re: recursive field value

alexandros17 — Fri, 19 Apr 2013 13:05:50 GMT

Yes, use "Above" function

hope it helps

Re: recursive field value

kaushiknsolanki — Fri, 19 Apr 2013 13:16:45 GMT

Hi,

Try this.

ABC:

Load * from ABC;

Load Customer,Active,Period_ID,previous(Active) as Previous_Active

Resident ABC order by Period_ID Asc;

Drop table ABC;

Regards,

Kaushik Solanki

Re: recursive field value

felcar2013 — Fri, 19 Apr 2013 14:52:43 GMT

thanks for your response

need to order by customer ID and Period ID, i tried this before, not expected result

Re: recursive field value

kuba_michalik — Fri, 19 Apr 2013 15:00:50 GMT

Did you check for changes in Customer value? Otherwise, first time a new Customer is loaded it would check whether the previous one was active. It should default to null in that situation.