topic Re: If statement error in QlikView

If statement error

Tue, 01 Jul 2014 20:21:59 GMT

I have created scripting error where my statement is IF(EvType= 15 AND EvParam1 > Lookup('SystemResponseTime','%MailBoxID',EvMailBoxID,'MailBox'), 'Not met Service Level', 'Met Service Level' ) AS ServiceEventLevelStatus, well you can imagine the part not Met Service level is correct however, For met service level I only want it so that IF(EvType= 15 AND EvParam1

Re: If statement error

Tue, 01 Jul 2014 20:23:35 GMT

I understand it is doing an else for all evTypes, I just need it for evType 15. Thank You in advance.

Re: If statement error

Greg_Williams — Tue, 01 Jul 2014 20:32:18 GMT

Is "15" a number or text? Table Viewer window > highlight over field > text or int/num? All is spelled correctly (case sensitive)? Perhaps use ( ) parenthesis to control the logic block.

Re: If statement error

Tue, 01 Jul 2014 20:36:37 GMT

Number
tinyint to be exact in the db

Re: If statement error

Tue, 01 Jul 2014 20:39:46 GMT

trying it but don't know where to block it up getting errors all around

Re: If statement error

Tue, 01 Jul 2014 20:47:02 GMT

I need to do it only for evtype 15 not the other evtypes, current with this statement IF(EvType= 15 AND EvParam1 > Lookup('SystemResponseTime','%MailBoxID',EvMailBoxID,'MailBox'), 'Not met Service Level', 'Met Service Level' ) AS ServiceEventLevelStatus,

I am getting the correct results for 'Not met Service level" but for met Service level it is showing that for all evTypes , However I just need it for evType 15

Re: If statement error

Greg_Williams — Tue, 01 Jul 2014 20:53:20 GMT

Just for clarification...

IF(EvType= 15 AND EvParam1 > Lookup('SystemResponseTime','%MailBoxID',EvMailBoxID,'MailBox'), 'Not met Service Level', 'Met Service Level' )

Translates to:

EvType = 15

AND

EvParam1 > "some number"

if True => 'Not met Service'

if False => 'Met Service level'

*** if no value found in Lookup - the value is Null.

Have you done a simple test of your Lookup logic to make sure that works alone (without If)?

Can try if( (EvType=15) AND (EvParam1>Lookup()), true, false

Re: If statement error

Tue, 01 Jul 2014 21:04:50 GMT

nope no null values, however if I switch the operators then it is still correct Current My express Translates to: if EvType = 15 AND EvParam1 > "some number" if True => 'Not met Service' if False => 'Met Service level' However I want it to show Translates to: if EvType = 15 AND EvParam1 > "some number" if True => 'Not met Service' if False => EvType = 15 AND EvParam1 > "some number"

Re: If statement error

Tue, 01 Jul 2014 21:05:47 GMT

= ' Met service level '

Re: If statement error

Greg_Williams — Tue, 01 Jul 2014 21:15:44 GMT

Your False logic is including EvTypes other than 15, even though you specified that logic in the If clause?

Perhaps consider using: an inline table or use 0 and 1 to test logic successfully, or use set analysis for the expression instead.

Re: If statement error

Wed, 02 Jul 2014 12:26:16 GMT

I need it to be a field, where the end user can choose if it has met or not, maybe a link key can work where I link
evtype, evparam1 and evparam2 ?

Re: If statement error

Greg_Williams — Wed, 02 Jul 2014 12:31:32 GMT

A list box can be created (from scratch)...and you can put in your own expression. Worth a try.

Re: If statement error

Wed, 02 Jul 2014 12:34:35 GMT

What would my expression be?

Re: If statement error

Wed, 02 Jul 2014 12:37:02 GMT

My apologizes I have never created a listbox embedded to an expression.

Re: If statement error

Greg_Williams — Wed, 02 Jul 2014 13:10:29 GMT

New Sheet Object > List Box... > Field > <Expression> > test logic to determine if this is working as expected > this will be able to provide choices that can be used to filter data elements.

Re: If statement error

Wed, 02 Jul 2014 14:02:39 GMT

I have tried the expression but receiving nothing

=IF(EvType= 15 AND EvParam1 > SystemResponseTime, 'Not met Service Level') OR IF(EvType= 15 AND EvParam1 <= SystemResponseTime, '

Is my OR if statement negating everything?

Re: If statement error

Greg_Williams — Wed, 02 Jul 2014 14:08:01 GMT

Without having a look at the data, the thing that concerns me is EvParam1 > SystemResponseTime (because sometimes - dates are not sometimes straight-forward...might require date(<date>,'MM-DD-YYYY') in logic. ...something like that. Have you tested one logic piece at a time to see if it works alone? Then we can stack the logic.

Re: If statement error

Wed, 02 Jul 2014 14:50:46 GMT

@evtype 15 the evparam1 is a number in seconds, and so is SystemResponseTime, My apologies for not clarifying that

Re: If statement error

Wed, 02 Jul 2014 14:51:54 GMT

I think it requires a nested if statement but I am not sure what to use

Re: If statement error

Greg_Williams — Wed, 02 Jul 2014 14:52:41 GMT

You can floor(<date>) to strip away the time > makes it easier to work with dates.