topic Re: Select ANY / OR from list in QlikView

Select ANY / OR from list

martynlloyd — Thu, 23 Jun 2016 11:48:53 GMT

I need to create a Chart/Table where the user can input a list of codes, and it will return rows where ANY of those codes appear in a string field

Example, data contains the field

Row1 P925945|P924974|P928690|P931245|P937145|P929622|P972233|P972583|P972583|P925777|P946333|

Row2 P952515|P921182|P954323|P925945|P924974|P928690|P931245|P937145|P929622|P972233|P972583|P972583|

Row3 P932986|P952515|P937145|P929622|P972233|P972583|P972583|P925777|P946333|

If user enters P925945, P924974 it will return Row1

If user enters P928690 it will return rows 1 & 2

If user enters P937145, P929622 it will return Rows 1, 2 & 3

Kind regards

MJ.

MK_QSL — Thu, 23 Jun 2016 11:51:35 GMT

Where these Rows are?

I mean in which objects?

Where you want user to enter values?

PrashantSangle — Thu, 23 Jun 2016 11:53:29 GMT

Hi,

Use search object..

Regards

effinty2112 — Thu, 23 Jun 2016 12:24:29 GMT

Hi Martyn

Using this script

Data:

LOAD

Row,

Data

Where Len(Data) >0;

Load

Row,

SubField(DataLine,'|') as Data;

Load

RecNo() as Row,

DataLine;

LOAD * INLINE [

DataLine

P925945|P924974|P928690|P931245|P937145|P929622|P972233|P972583|P972583|P925777|P946333|

P952515|P921182|P954323|P925945|P924974|P928690|P931245|P937145|P929622|P972233|P972583|P972583|

P932986|P952515|P937145|P929622|P972233|P972583|P972583|P925777|P946333|

];

you can add a listbox on the field Data and a textbox with the expression Concat(DISTINCT Row,', ') will give the row numbers.

Cheers

Andrew