topic Re: Mistake in Statement in QlikView

Mistake in Statement

carolin01 — Thu, 03 Apr 2014 13:54:34 GMT

Hello,

can anybody tell me what I´m doing wrong with this statement:

Load

BaseItem,
Len (BaseItem) as BaseItemLength,
'Sensor' as BaseItemDesc1,
'G-Series' as BaseItemDesc2,
mid(BaseItem, 1, 2) as Design,
'Standard rod version' as HousingType,
mid(BaseItem, 3, 1) as DESIGN_OP,
'' as MAGNET_TYPE,
'' as MAGNET_TYPE_DESC,
mid(BaseItem, 4, 4) as LENGTH,
mid(BaseItem, 8, 1) as LENGTH_DESC,
mid(BaseItem, 9, 3) as Connection_Type,
if(mid(BaseItem,9,1 = 'D', '',
if(mid(BaseItem,9,1 = 'M', '',
if(mid(BaseItem,9,3 = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00', '',
(mid(BaseItem, 10, 2)))))))) as CableLenght,
mid(BaseItem, 12, 1) as Options,
mid(BaseItem, 13, 6) as POS_OUT
Resident dProductsLud
Where (mid(BaseItem, 1, 2) = 'GH');

I just don´t see it where I´m doing the mistake for field CableLenght. Many thanks for your help in advance!!!

Re: Mistake in Statement

crusader_ — Thu, 03 Apr 2014 14:00:43 GMT

Hi Carolin,

Try to unpack your statement, as I understood you meant :

if(mid(BaseItem,9,1) = 'D', '',
if(mid(BaseItem,9,1) = 'M', '',
if(mid(BaseItem,9,3) = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00', '',
(mid(BaseItem, 10, 2))))) as CableLenght,

You didn't close the brackets in mid()

And you ain't allowed to do that

mid(BaseItem,9,3) = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00'

Andrei

Re: Mistake in Statement

its_anandrjs — Thu, 03 Apr 2014 14:01:27 GMT

In below line of statement you did mistake

if(mid(BaseItem,9,3 = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00','',

your mid function is not correct also so many conditions i suggest use match for this if there are many condition.

Re: Mistake in Statement

Thu, 03 Apr 2014 14:01:32 GMT

Hi Caroline,

(mid(BaseItem,9,1 = 'D', '',

missing closing bracket

(mid(BaseItem,9,1)= 'D', '',

and so on?

Small typo in the name as well

Re: Mistake in Statement

alexandros17 — Thu, 03 Apr 2014 14:03:14 GMT

if(mid(BaseItem,9,1 = 'D', '',
if(mid(BaseItem,9,1 = 'M', '',
if(mid(BaseItem,9,3 = 'RB1' or 'RB2' or 'FM1' or 'FM2' or 'RR8' or 'RR4' or 'RR5' or 'RR6' or 'RRH' or 'FD1' or 'FD2' or 'K00', '',
(mid(BaseItem, 10, 2)))))))) as CableLenght,

mid(BaseItem,9,3 ... you have missed the ) of closure (also in next mid...)

Hope it helps

Re: Mistake in Statement

Thu, 03 Apr 2014 14:05:31 GMT

Hi Carolin Borchert ,

'' as MAGNET_TYPE,
'' as MAGNET_TYPE_DESC,

what is this in your script?

this is wrong in u r script.

Thank you

Re: Mistake in Statement

its_anandrjs — Thu, 03 Apr 2014 14:19:49 GMT

There are many mistakes in the script like

1.mid function using in if mid(BaseItem, 12, 1) but not clearly define,

2. Many conditions like 'RB1','RB2','FM1','FM2','RR8' with or which is not clearlly define

3. Closing brackets not apply correctly

Re: Mistake in Statement

its_anandrjs — Thu, 03 Apr 2014 14:28:41 GMT

Here is your complete load statement

Load

BaseItem,

Len (BaseItem) as BaseItemLength,

'Sensor' as BaseItemDesc1,

'G-Series' as BaseItemDesc2,

mid(BaseItem, 1, 2) as Design,

'Standard rod version' as HousingType,

mid(BaseItem, 3, 1) as DESIGN_OP,

'' as MAGNET_TYPE,

'' as MAGNET_TYPE_DESC,

mid(BaseItem, 4, 4) as LENGTH,

mid(BaseItem, 8, 1) as LENGTH_DESC,

mid(BaseItem, 9, 3) as Connection_Type,

if(mid(BaseItem,9,1) = 'D', '',

if(mid(BaseItem,9,1) = 'M', '',

if(Match(mid(BaseItem,9,3), 'RB1', 'RB2', 'FM1', 'FM2', 'RR8', 'RR4', 'RR5', 'RR6', 'RRH', 'FD1', 'FD2', 'K00'), '',(mid(BaseItem, 10, 2))))) as CableLenght,

mid(BaseItem, 12, 1) as Options,

mid(BaseItem, 13, 6) as POS_OUT

Resident dProductsLud

Where (mid(BaseItem, 1, 2) = 'GH');

with new update.