Creating a flag on date(help needed urgently

[#1]

Hello All,

I need to create a flag for the order_enddate stating if its 1 then the order ended that day.

Master calender is based on the order_date.

i am creating a flag for order_date using the below script.

please help me with how can i create a flag for the order_end_date also.

Load

  order_id,

  Date(order_date + IterNo() - 1) as date_id,

  if(IterNo()=1,1) as order_sign_flag,

  '1' as lease_days

Resident order

While IterNo() <= order_enddate - order_date;

Order_id	Order_date	Order_startdate	Order_Enddate	Order_sign_flag
1	10.01.2014	12.01.2014	16.01.2014
2	11.02.2014	13.02.2014	17.02.2014
3	10.03.2014	15.03.2014	18.03.2014
4	11.04.2014	18.04.2014	22.04.2014

Appreciate your help with this.

Thanks & Regards,

Jaya

[sunny_talwar · Accepted solution]

You want this?

Script:

order:

LOAD Order_id,

    Order_date,

    Order_startdate,

    Order_Enddate

FROM

[https://community.qlik.com/thread/218538]

(html, codepage is 1252, embedded labels, table is @1)

Where Len(Trim(Order_id)) > 0;

Table:

LOAD Order_id,

  date_id,

  order_sign_flag,

  lease_days,

  If(date_id = Order_Enddate, 1) as order_end_date_flag;

LOAD Order_id,

  Order_Enddate,

  Date(Order_date + IterNo() - 1) as date_id,

  if(IterNo()=1,1) as order_sign_flag,

  '1' as lease_days

Resident order

While IterNo() <= Order_Enddate - Order_date + 1;

DROP Table order;

[#3]

Thanks Sunny.

Yes this is what I was looking for.

Appreciate your help.

Regards,

Jaya