topic Criteria select in a script with special characters '<' in QlikView

Criteria select in a script with special characters '<'

pperrochaud — Mon, 01 Apr 2019 11:11:46 GMT

Hello,

In a Xls file the possible value of a field is '<--->' and I have to select only rows whith this value.

I wrote my script like this:

Offers_Diffus_tmp:
LOAD DateOffre,
Référence,
Marque,
Famille,
Produit,
Quantité,
[Prix de base],
[Prix client],
[Prix négoce],
[Prix total],
Client
FROM
$(vOffers_Diffus)
(ooxml, embedded labels)
where Référence = '<--->';

But no line is loaded.

Could you help me please ?

Re: Criteria select in a script with special characters '<'

sunny_talwar — Mon, 01 Apr 2019 11:34:59 GMT

May be try this

Where Trim(Référence) = '<--->';

or this

Where WildMatch(Référence, '*<--->*');

Re: Criteria select in a script with special characters '<'

amrinder — Mon, 01 Apr 2019 11:54:46 GMT

Hi,

Try below:

Let vWildChar=chr(60)&'*';

Hope it helps.

-amrinder

Re: Criteria select in a script with special characters '<'

amrinder — Mon, 01 Apr 2019 11:59:30 GMT

Sorry I passed wrong variable name in where clause please correct it:

Try below:

Let vWildChar=chr(60)&'*';

Offers_Diffus_tmp:
LOAD DateOffre,
Référence,
Marque,
Famille,
Produit,
Quantité,
[Prix de base],
[Prix client],
[Prix négoce],
[Prix total],
Client
FROM
$(vOffers_Diffus)
(ooxml, embedded labels)
where where WildMatch(Référence,'$(vWildChar)');

Regards,
Amrinder

Re: Criteria select in a script with special characters '<'

pperrochaud — Mon, 01 Apr 2019 12:17:21 GMT

Thanks It's works.