topic Re: 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. in QlikView

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 — Wed, 25 Jul 2018 07:28:19 GMT

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!

Re: 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.

neelamsaroha157 — Wed, 25 Jul 2018 20:28:46 GMT

You can use IF condition as -

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

Re: 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 — Thu, 26 Jul 2018 12:23:19 GMT

Thanks neelam