topic Re: If function searching for case sensitive text in QlikView

If function searching for case sensitive text

Fri, 22 Jul 2016 20:46:41 GMT

Hello,

I have a set of data that I need to qualify based on the text of a field and it is case sensitive. The current load script is pulling ANYTHING that starts with clinical and I need it to recognize CLINICAL all in caps only.

Load

Metric,

Type,

Title,

Date,

If(Title LIKE 'CLINICAL*' and Metric = 'Letters', 'Include', 'Exclude') as Status

From

(ooxml, embedded labels, table is Sheet1);

How can I get it to be case sensitive? Any help is greatly appreciated.

Re: If function searching for case sensitive text

sunny_talwar — Fri, 22 Jul 2016 21:35:23 GMT

How about this:

LOAD Metric,

Type,

Title,

Date,

If(Match(Left(Title, 8), 'CLINICAL') and Metric = 'Letters', 'Include', 'Exclude') as Status

From

(ooxml, embedded labels, table is Sheet1);

Re: If function searching for case sensitive text

vishsaggi — Fri, 22 Jul 2016 21:41:48 GMT

Did not try may be like this?

IF(WildMatch(Title, 'CLINICAL*') AND Metric = 'Letters','Exclude','Include') AS Status

Re: If function searching for case sensitive text

Fri, 22 Jul 2016 21:58:55 GMT

Thank you for the information. Wildmatch still brings both caps and lower case.

Re: If function searching for case sensitive text

Fri, 22 Jul 2016 21:59:42 GMT

This worked perfectly, as Match is case sensitive. Now I know how to use it in an IF statement. Thank you so much!

Re: If function searching for case sensitive text

sunny_talwar — Fri, 22 Jul 2016 22:08:50 GMT

Ya I think WildMatch and MixMatch are both Case Insensitive. I did not know about Like, but it seems it is. But Match is case sensitive and so is a simple =...

If(Left(Title, 😎 = 'CLINICAL' ....

Re: If function searching for case sensitive text

MarcoWedel — Sat, 23 Jul 2016 00:02:20 GMT

Hi,

another solution could be:

table1:

LOAD RecNo() as ID,

Metric,

Title,

If(Index(Title,'CLINICAL')=1 and Metric = 'Letters', 'Include', 'Exclude') as Status

INLINE [

Metric, Title

Letters, CLINICAL

no Letters, CLINICAL

Letters, CLINICAL1

no Letters, CLINICAL1

Letters, Clinical

no Letters, Clinical

Letters, Clinical2

no Letters, Clinical2

Letters, None CLINICAL

no Letters, None CLINICAL

Letters, something else

no Letters, something else

];

hope this helps

regards

Marco