topic Re: Pick the perticular word in QlikView

Pick the perticular word

ravindraa — Thu, 14 Aug 2014 06:15:02 GMT

Hi all,

I have struck one place, my requierment is we have two field like below.

Company name, sales

Samsung_Galaxys5, 1

Samsung galaxys5, 4

sonyexperiaxz, 4

Samsung_Galaxys6, 6

Samsung_Galaxys7, 7

here we need to display the value like when company name have '_' next value need othere wise need to display the all values.

Galaxys5,

Galaxys6,

Galaxys7,

sonyexperiaxz,

Samsung galaxys5

to get this i have wrote below expression in caliculated Dimension like below.

subfield([company name],'_',2) in this case i am getting only like below.

Galaxys5,

Galaxys6,

Galaxys7,

i am losing below values

sonyexperiaxz,

Samsung galaxys5

please guide me any one how to do this. thanks.

Re: Pick the perticular word

sujeetsingh — Thu, 14 Aug 2014 06:18:47 GMT

Try using wildmatch() function

Re: Pick the perticular word

tresB — Thu, 14 Aug 2014 06:19:50 GMT

Try like:

If (Index([company name], '_'), subfield([company name],'_',2) , [company name]) as NewField

Re: Pick the perticular word

ravindraa — Thu, 14 Aug 2014 06:26:51 GMT

Thank Tresesco,

Now it is working fine, thank you very much....

Re: Pick the perticular word

sujeetsingh — Thu, 14 Aug 2014 06:30:19 GMT

Here is a script for you

Dqata:

LOAD * INLINE [

Company name, sales

Samsung_Galaxys5, 1

Samsung galaxys5, 4

sonyexperiaxz, 4

Samsung_Galaxys6, 6

Samsung_Galaxys7, 7

];

ETL:

LOAD *,

SubField([Company name],'_',2) as new

,SubField([Company name],' ',2) as new2

Resident Dqata;

DROP Table Dqata;

Data:

LOAD

[Company name],

sales,

if(len(new)=0 and len(new2)=0,[Company name], if(len(new)=0,new2,new)) as Model

Resident ETL;

Re: Pick the perticular word

ravindraa — Thu, 14 Aug 2014 06:37:37 GMT

Thanks Sujeetsingh,

it is also working fine ,thanks you very much.

Re: Pick the perticular word

sujeetsingh — Thu, 14 Aug 2014 07:02:27 GMT

You are always welcome man