Code

[smilingjohn]

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

[Chanty4u]

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.h...

[#3]

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'

[smilingjohn]

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

[Chanty4u]

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;

[Anonymous]

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,

[gajapathy74]

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