Solved: Re: Flag for Date - Qlik Community

Anonymous · ‎2017-03-31

Hi All,

I have date against order number and i some order have order date and some order don't have date like pending order So i want to create flag for it.

PFA for expected output.

Thanks

avinashelite · ‎2017-03-31

I checked your QVW , you don't have any - or null values as you mentioned above in the ForeclosureDate that's why its not populating the Not forced close ..check your data set

if(year(ForeclosureDate)='1753','NA', date(ForeclosureDate,'DD-MM-YYYY')) as ForeclosureDate,

,if(len(trim(ForeclosureDate))>0 and (ForeclosureDate)<>'NA','Forced Closed' ,'Not Forced Closed') as Flag

View solution in original post

sunny_talwar · ‎2017-03-31

May be like this

LOAD Order,

Date,

If(Len(Trim(Date)) = 0, 'Pending Order', 'Order Done') as Flag

FROM ....;

Anonymous · ‎2017-03-31

Hi Sunny,

I dont have any null values in date so if i use your solution then it is getting only Order Done in flag.

ahaahaaha · ‎2017-03-31

Hi,

May be like this

LOAD Order,

Date,

If(Left(Order, 5)=' ORD/', 'Order Done', 'Pending Order') as Flag

FROM ....;

Regards,

Andrey

Anonymous · ‎2017-03-31

PFA ...

Any suggestion ...

avinashelite · ‎2017-03-31

on which column base you need this flag to be create ?? could elaborate bit more

Anonymous · ‎2017-03-31

Based on Order number.

sunny_talwar · ‎2017-03-31

What are you trying to do in the attached file? Would you be able to elaborate?

Anonymous · ‎2017-03-31

In my chart i don't want those order number which they have forclosure date .

sunny_talwar · ‎2017-03-31

May be this?