QlikView App Dev

priyankashrivas · ‎2018-07-25

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 · ‎2018-07-25

You can use IF condition as -

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

View solution in original post

neelamsaroha157 · ‎2018-07-25

You can use IF condition as -

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

priyankashrivas · ‎2018-07-26

Thanks neelam

QlikView App Dev

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.