topic Re: Check for particular value in a text field. in QlikView

Check for particular value in a text field.

psk180590 — Sat, 16 Nov 2024 21:31:50 GMT

Hello All,

I have the following values in my data.

TEXT:

A01// External Sales Data

A13// TV Campaign

No Activity

Here, i would like to check if the values in TEXT have // and then extract the first 3 values.

From the above mentioned data i would like to only display A01 and A13.

TIA

Sai.

Re: Check for particular value in a text field.

sergio0592 — Sat, 26 Jan 2019 22:34:56 GMT

Hi,

It works with :

TEXT:
load if (wildmatch(Field,'*//*'), SubField(Field,'//',1),'') as Field2
inline [
Field
A01// External Sales Data
A13// TV Campaign
No Activity];

Re: Check for particular value in a text field.

Anil_Babu_Samineni — Sun, 27 Jan 2019 00:27:23 GMT

Perhaps this?
If(istext(field), sibfield(field, '//', 1), field) as new

Re: Check for particular value in a text field.

MindaugasBacius — Sun, 27 Jan 2019 09:48:57 GMT

I would prefer using Index and Left functions. Take a look:

LOAD *
	,If(Index(text, '//'), Left(text, 3), null()) as Result
INLINE [
text
A01// External Sales Data
A13// TV Campaign
No Activity
];

This is your expected results:

Also, I do advise you instead of Null() in If statement to you something that's easy to count and find.

If(Index(text, '//'), Left(text, 3), ':') as Result

Re: Check for particular value in a text field.

psk180590 — Mon, 04 Feb 2019 14:45:47 GMT

Thanks all for you valubale suggestions.
For the same data i have found out that there is another Text field, now i have to check both the fields and then extract the Value if exists in either one of them.

Please, check the attached excel.

In the first Column Text2 is Empty, Second one has Text Empty, Third one has both the Values same and the Fourth one has no Values.

TIA!!