topic Re: Flag Creation in script in QlikView

Flag Creation in script

brijesh1991 — Fri, 16 Aug 2013 08:40:07 GMT

Hi all,

I wanted to create a flag at script level.
My data is like this:
Load * inline
[
AppNo, Date
123, 12/11/2013
123,
124,12/10/2012
124, 10/05/2012
125,
125
126,10/12/2012
];

There are multiple dates against a single AppNo, I wanted to create a flag against AppNo. if any one Date is null against AppNo, then Flag=N else Y

So my output should be like this:

AppNo, Date, Flag
123, 12/11/2013, N
123,                  ,N
124,12/10/2012, Y
124, 10/05/2012, Y
125,                  , N
125                  , N
126,10/12/2012, Y

Your help is valuable to me. . .

Best Regards,
BRIJESH

Re: Flag Creation in script

tresB — Fri, 16 Aug 2013 08:43:35 GMT

try this:

Load

AppNo,

Date,

If (Isnull(Date), 'N', 'Y') as Flag

From <>;

Re: Flag Creation in script

brijesh1991 — Fri, 16 Aug 2013 09:33:29 GMT

thanks tres qv. . .

AppNo, Rcvd
123, 12/11/2012
123,
Since there are multiple dates against each AppNo, for above case your solution will give flag 'Y'. Actually it should be 'N' I think we need to do some group by. but getting some script error. Try from your end and let me know if u find some fruit! Best Regards, Brijesh

Re: Flag Creation in script

Fri, 16 Aug 2013 10:15:04 GMT

Hi,

See the attachment.

Re: Flag Creation in script

tresB — Fri, 16 Aug 2013 10:32:02 GMT

PFA.

Is this what you want?

Re: Flag Creation in script

brijesh1991 — Fri, 16 Aug 2013 13:19:23 GMT

Hey tres. .. . This is exactly what I was looking for. . . Thanks buddy and FindOneOf is nice function at time of deriving such complicated Flag. . . Really impressed. . . Thanks again. . . Brijesh :))