topic Finding the Records in QlikView

Finding the Records

l8b9plyodvynlk2 — Thu, 26 May 2022 09:45:50 GMT

Hi Team,

I have data

Category Name

Men's Clothes

Women's Clothes

Sportswear

Swimwear

can you please how to resolve this issue

I'm finding this record where [Category Name] = 'Sportswear'

but unable to finding this record.

where [Category Name] = 'Men's Clothes'

Re: Finding the Records

edwin — Thu, 26 May 2022 10:34:02 GMT

pls post your script

Re: Finding the Records

saranyadurai — Thu, 26 May 2022 11:07:39 GMT

Hi @l8b9plyodvynlk2 ,

you can try this,

where [Category Name] = 'Men''s Clothes' ;

Use single quotes twice in Men's

You can read more about this,

Escape sequences

Thanks

Re: Finding the Records

l8b9plyodvynlk2 — Thu, 26 May 2022 14:13:50 GMT

1. it is excuting

Category:
LOAD [Category Name],
Description
FROM
[D:\QlikTutorials\Qlik classes videos\QWT Analysis.xlsx]
(ooxml, embedded labels, table is Category)
where [Category Name] = 'Sportswear';

2. it is not executing

Category:
LOAD [Category Name],
Description
FROM
[D:\QlikTutorials\Qlik classes videos\QWT Analysis.xlsx]
(ooxml, embedded labels, table is Category)
where [Category Name] = 'Men's Clothes';

Re: Finding the Records

l8b9plyodvynlk2 — Thu, 26 May 2022 14:34:14 GMT

Yes, Thanks a lot. its working. thanks for your valuable time😊.