topic Re: Logic Issue (IF) in QlikView

Logic Issue (IF)

tmumaw — Fri, 29 Jul 2016 12:30:16 GMT

Does anyone see anything wrong with this logic? Thanks......

if(mid(MntPlan_WARPL,1,3) = 'PMA', mid(MntPlan_WARPL,1,3),
if(mid(MntPlan_WARPL,1,5) = 'PMA/D', mid(MntPlan_WARPL,1,5))) as PM_Type,

Clever_Anjos — Fri, 29 Jul 2016 12:32:40 GMT

mid(MntPlan_WARPL,1,5) = 'PMA/D' would never be satisfied since mid(MntPlan_WARPL,1,3) = 'PMA' is satisfied first

antoniotiman — Fri, 29 Jul 2016 12:35:18 GMT

This is correct sintax.

Ovewer if You have 'PMA/D' You also have 'PMA'

So, else condition never works.

I suggest to revers conditions.

Regards,

Antonio

tmumaw — Fri, 29 Jul 2016 12:37:23 GMT

Thanks.....too early in the morning and only one cup of coffee......

Clever_Anjos — Fri, 29 Jul 2016 12:41:46 GMT

I´ve already have 3 cups