topic Creating a flag on date(help needed urgently in QlikView

Creating a flag on date(help needed urgently

Fri, 27 May 2016 06:11:52 GMT

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

Re: Creating a flag on date(help needed urgently

sunny_talwar — Fri, 27 May 2016 16:22:41 GMT

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;

Re: Creating a flag on date(help needed urgently

Wed, 01 Jun 2016 07:28:09 GMT

Thanks Sunny.

Yes this is what I was looking for.

Appreciate your help.

Regards,

Jaya