topic Re: Logic.... in QlikView

Logic....

tmumaw — Fri, 29 Jul 2016 14:08:20 GMT

Anyone see anything wrong with this:

if(mid(MntPlan_WARPL,1,5) = 'PMH/J',mid(MntPlan_WARPL,1,5),

if(mid(MntPlan_WARPL,1,5) = 'PMC/D',mid(MntPlan_WARPL,1,5),

if(mid(MntPlan_WARPL,1,3) = 'PMN',mid(MntPlan_WARPL,1,3),

if(mid(MntPlan_WARPL,1,3) = 'PML',mid(MntPlan_WARPL,1,3),

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

Thanks

Digvijay_Singh — Fri, 29 Jul 2016 14:16:18 GMT

Looks fine to me syntax wise. What error you are facing?

Clever_Anjos — Fri, 29 Jul 2016 14:16:45 GMT

No visible issue.

What is being returned?

Anonymous — Fri, 29 Jul 2016 14:17:16 GMT

Hi Thom.

Seems good to me. What are you trying to achieve and what are the errors you are facing here?

tmumaw — Fri, 29 Jul 2016 14:28:19 GMT

PMA only is being returned

Clever_Anjos — Fri, 29 Jul 2016 14:37:22 GMT

It would be possible if you post a sample of your data?

Anonymous — Fri, 29 Jul 2016 14:43:46 GMT

Hi thom,

I'm thinking maybe this is what you are trying to achieve?

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PMH/J'), 5) = 'PMH/J','PMH/J',

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PMC/D'), 5) = 'PMC/D','PMC/D',

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PMN'), 3) = 'PMN','PMN',

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PML'), 3) = 'PML','PML',

if(MID(MntPlan_WARPL, Index(MntPlan_WARPL,'PMA'), 3) = 'PMA','PMA',))))) as PM_Type

Anil_Babu_Samineni — Fri, 29 Jul 2016 15:29:19 GMT

Might be this

if(mid(MntPlan_WARPL,1,5) = "PMH/J",mid(MntPlan_WARPL,1,5),

if(mid(MntPlan_WARPL,1,5) = "PMC/D",mid(MntPlan_WARPL,1,5),

if(mid(MntPlan_WARPL,1,3) = "PMN",mid(MntPlan_WARPL,1,3),

if(mid(MntPlan_WARPL,1,3) = "PML",mid(MntPlan_WARPL,1,3),

if(mid(MntPlan_WARPL,1,3) = "PMA",mid(MntPlan_WARPL,1,3)))))) as PM_Type