Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
priyankashrivas
Contributor II
Contributor II

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.

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!

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

You can use IF condition as -

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

View solution in original post

2 Replies
neelamsaroha157
Specialist II
Specialist II

You can use IF condition as -

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

priyankashrivas
Contributor II
Contributor II
Author

Thanks neelam