topic Re: Creating Flag for Time in QlikView

Creating Flag for Time

rajkumarb — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

i have a time field SoldTime(dd-mm-yyyy hh:ss:fff), i need to create a flag for that field in the load script

if sales made before 12:00 = Y

and sales made after that =N

Please suggest how to do that

swuehl — Tue, 13 Jun 2017 15:46:24 GMT

Set TimestampFormat = 'DD-MM-YYYY hh:mm:ss:fff'; // or whatever your real format is

LOAD

SoldTime,

If( Frac(SoldTime) <0.5, 'Y','N') as Flag,

...

Gysbert_Wassenaar — Tue, 13 Jun 2017 15:46:26 GMT

Perhaps like this: If(Frac(SoldTime)<0.5,'Y','N') as Flag