Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Re: If statement error

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  ?

Employee
Employee

Re: If statement error

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

Not applicable

Re: If statement error

What would my expression be?

Not applicable

Re: If statement error

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

Highlighted
Employee
Employee

Re: If statement error

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.

Not applicable

Re: If statement error

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?

Employee
Employee

Re: If statement error

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.

Not applicable

Re: If statement error

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

Not applicable

Re: If statement error

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

Employee
Employee

Re: If statement error

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