Discussion Board for collaboration on QlikView Scripting.
HI all ,
Please help me to create a FLAG column below table where for each NUMBER to get Last flag as 1 else 0
Go to Solution.
Try like this
If(Peek('NUMBER') <> NUMBER, 1, 0) AS Flag
Hope this helps you.
Do you have Timestamp format of Date? If so it will be easy to flag the latest Status based on max(Date)
yes have timestamp
can you plz share script hear .
make sure that You Date is in proper Timestamp format
num(Date) as Date,
max(Date) as Date
1 as MaxDateFlag
group by Number;
if(len(trim(MaxDateFlag))<=0,0,MaxDateFlag) as Flag
drop table Data;
You can simply use maxstring(date)..