I have to create 2 fields valid flag and invalid flag based on the three fields. If any of the three fields is 0 or negative, pass invalid flag, else valid flag. Can you please guide me how can i do this.

[priyankashrivas]

I have to create 2 fields in Qlikview script valid flag and invalid flag based on the three fields  i already have. If any of the three fields is 0 or negative, pass invalid flag, else valid flag. Can you please guide me how can i do this.

Urgent help would be appreciated.

Thanks in advance!

[neelamsaroha157 · Accepted solution]

You can use IF condition as -

If(Field1<1 or Field2<1 or Field3<1, 'Invalid', 'Valid') as Flag

[priyankashrivas]

Thanks neelam