topic Create a flag column based on NUMBER in QlikView

Create a flag column based on NUMBER

sunilkumarqv — Thu, 17 Mar 2016 07:30:57 GMT

HI all ,

Please help me to create a FLAG column below table where for each NUMBER to get Last flag as 1 else 0

Kushal_Chawda — Thu, 17 Mar 2016 07:38:36 GMT

Do you have Timestamp format of Date? If so it will be easy to flag the latest Status based on max(Date)

sunilkumarqv — Thu, 17 Mar 2016 07:43:34 GMT

yes have timestamp

can you plz share script hear .

jagan — Thu, 17 Mar 2016 07:59:28 GMT

Hi,

Try like this

LOAD

If(Peek('NUMBER') <> NUMBER, 1, 0) AS Flag

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Kushal_Chawda — Thu, 17 Mar 2016 08:45:12 GMT

make sure that You Date is in proper Timestamp format

Data:

LOAD Number,

num(Date) as Date,

Status

From Table;

left join(Data)

LOAD Number,

max(Date) as Date

1 as MaxDateFlag

Resident Data

group by Number;

Final:

noconcatenate

LOAD *,

if(len(trim(MaxDateFlag))<=0,0,MaxDateFlag) as Flag

resident Data;

drop table Data;

siddharthsoam — Fri, 25 Jan 2019 06:51:25 GMT

You can simply use maxstring(date)..