Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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