Time field how to flag when value is null ?

[#1]

Hi All I have a field which is Time steam , i like to flag those value with nul. may i Hi All I have a field which is Time steam , i like to flag those value with nul. may i know how to do it ? using the load script . Paulknow how to do it ? using the load script . Paul

[#2]

hi,

     try this in your load script:

load

[AC-No.],

     Name,

     Date,

     Timetable,

     If(IsNull([Clock In]) or [Clock In]='' , 0, [Clock In]) as  [Clock In],

     [Clock Out],

     Late

From

tablename

some time field may be empty also so it will not check with null condition so you have add condition for empty value also.

hope this helps you.

Regards,

Ashutosh

[israrkhan]

Try like below:

Table:

load

[AC-No.],

     Name,

     Date,

     Timetable,

     If(IsNull([Clock In]) or Len(Trim([Clock In])) = '' , 0, 1) as  TimeFlag,

     [Clock Out],

     Late

From ABC

now in front end you could write like,

sum({<TimeFlag =1>}Value), it will bring where time is not null or empty

sum({<TimeFlag =0>}Value) it will bring where time is null or empty.

Hope it helps..

[VishalWaghole]

Hi Paul,

Try this

if(isNull([Clock In]),'FLAG FOR NULL','FLAG FOR NOT NULL') as NULL_FLAG

Thanks and Regards,

Vishal Waghole

[qlikpahadi07 · Accepted solution]

Hi,

Find the attachment you can reload and can find one more Field named as Flag

hope that works

if(Len([Clock In]) <1,'Null','Time in') as Flag,

[#6]

Hi All

Many Thank for help me with the script . Rohit script is the best because :-

1. it allow me to select null or not null.

2. it work.

Paul