topic Re: Code in QlikView

Code

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can someone explain me what does the below code is doing ?

where (Department='TT' and not match([Code dep],'IP-0AF5C33F\NNMoLI')) or left([Code dep],10) ='TT_BT';

Thanks

Re: Code

Chanty4u — Fri, 11 Nov 2016 05:12:26 GMT

Hi,

it will give you the below result.

Where(Dep='TT') means it wil display only related to 'TT' department and [Codedep] not equal to='IP-0AF5C33F\NNMoLI or it will display first 10 letters in the [Code dep]

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/Left.htm

Re: Code

Fri, 11 Nov 2016 05:14:55 GMT

It brings the data only the Department field value is 'TT' and

Code dep not equal to 'IP-0AF5C33F\NNMoLI' or

Code dep is like (the value is which is extracted 10 charecters from left side) that eqaual to 'TT_BT'

Re: Code

smilingjohn — Fri, 11 Nov 2016 05:18:57 GMT

Hi chanty thanks for the explanation , can you please tell me what is this doing ,iam confused now

or left([Code dep],10) ='TABLETS_BT'; ? is giveing [Code dep] =TABLETS_BT becuase this are 10 words

Re: Code

Chanty4u — Fri, 11 Nov 2016 05:24:34 GMT

Hi,

Did you checked the aboe link which i have mentioned above it gives you clarification for your doubt.

check sample example:

DATA:

LOAD * INLINE [

CODE

ADMNNFNFNFNFN

AJDJFIMIKMEKM

NSAJJFMGKGMGM

];

RESULT:

LOAD *,

Left(CODE,5) AS NEW

Resident DATA;

Re: Code

Anonymous — Fri, 11 Nov 2016 05:32:36 GMT

Hi John,

code: where (Department='TT' and not match([Code dep],'IP-0AF5C33F\NNMoLI')) or left([Code dep],10) ='TT_BT';

applying following condition

1. Department='TT'

2. and [Code dep] should not equal to (<>) 'IP-0AF5C33F\NNMoLI'

3 or count of 10 characters of [Code dep] from left should be 'TT_BT'

Thanks,

Re: Code

gajapathy74 — Fri, 11 Nov 2016 06:59:06 GMT

It will give the rows that [Code dep] having values of 'TABLETS_BT' at the beginning.