topic Re: If condition giving incorrect result in QlikView

If condition giving incorrect result

Anonymous — Fri, 29 Jun 2018 05:02:44 GMT

Hey Guys,

I am writing below logic so that when status is not equal to 3 or 4 it should display Unprocessed else Processed.

if ([statut] <>'3' or '4', 'Unprocessed', 'Processed') as Flag

But in qlikview after I write the above condition, I get Unprocessed if Status=3, which is wrong according to this above logic.

Can you please help me with the above issue?whether my calculation wrong?

Re: If condition giving incorrect result

keerthika — Fri, 29 Jun 2018 05:18:59 GMT

Hi ,

Try this =if(wildmatch(status,'3','4')>=1,'Processed','Unprocessed')

Re: If condition giving incorrect result

tresB — Fri, 29 Jun 2018 05:45:21 GMT

May be this?

if ( Not Match ([statut], '3', '4'), 'Unprocessed', 'Processed') as Flag

Re: If condition giving incorrect result

gayathri_nagara — Fri, 29 Jun 2018 05:47:30 GMT

Hi,

Check this whether it is useful

status:

LOAD * INLINE [

Status

];

load *,

if(Status = '3' or Status = '4', 'UnProcessed') as Flag

Resident status;

load *,

if(Status <> '3' or Status <> '4', 'Processed') as Flag

Resident status;

Re: If condition giving incorrect result

ashwin_r — Fri, 29 Jun 2018 06:20:36 GMT

Try this,

if ([status] <>3 or [status]<>4, 'Unprocessed', 'Processed') as Flag

Re: If condition giving incorrect result

dapostolopoylos — Fri, 29 Jun 2018 06:20:58 GMT

Try:

=if(Match(status,'3','4'),'Processed','Unprocessed')

Re: If condition giving incorrect result

olivierrobin — Fri, 29 Jun 2018 07:03:36 GMT

hello

due to operator precedence, your formula is equivalent to

[statut] <>('3' or '4')

try with match function for example

Re: If condition giving incorrect result

tresB — Fri, 29 Jun 2018 07:26:48 GMT

Hi Olivier,

Olivier Robin wrote:

hello

due to operator precedence, your formula is equivalent to

[statut] <>('3' or '4')

try with match function for example

I guess that's not correct. In fact,

if ([statut] <>'3' or '4'

is being evaluated as: if ( ([statut] <>'3') or '4' ..........., i.e it is evaluating two separate conditions, one for [statut]<>'3' and second one just '4', which is actually TRUE always (any number except '0' is 'true'). Therefore, the condition effectively becomes : if ( ([statut] <>'3') or TRUE() , ... I.e. - 'something OR TRUE' - which would always return a TRUE.