This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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,
mid(MntPlan_WARPL,1,5) = 'PMA/D' would never be satisfied since mid(MntPlan_WARPL,1,3) = 'PMA' is satisfied first
View solution in original post
This is correct sintax.
Ovewer if You have 'PMA/D' You also have 'PMA'
So, else condition never works.
I suggest to revers conditions.
Thanks.....too early in the morning and only one cup of coffee......
I´ve already have 3 cups