Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search Value in comma delimited Field

Hi all,

I need help to search value in comma delimited filed.   Can somebody help me.  if you already have a sample qvw is also appreciated.

Eg. Filter power outages which impacted selected region

Outage date    outage id  outage regions  ( simple table)

01/01/2013  1                    EAST, NORTH

02/01/2013  2                    SOUTH,WEST

03/02/2013  3                     EAST

List of unique regions (List box for filter)   ,

EAST

NORTH

WEST

SOUTH

Thanks

Chakri

9 Replies
tresesco
MVP
MVP

Use subfield() that creates separate records for all delimited values of a field. Try like:

Load

          [Outage Date],

          [Outage Id],

          SubField([Outage Region], ',') as [Outage Region]

From <>;

Not applicable
Author

Thanks

This could be one way but i do not want display multiple records   in  detail list  in case i search for two or more regions  "NORTH,WEST"  in    search box. 

Anonymous
Not applicable
Author

You can use Wildcard search

Not applicable
Author

could you please give me example or sample

I expect user select one or many by clicking in List box.

Anonymous
Not applicable
Author

Hi

by for list search filter selecting the Spl column can reach the requirement

DATA;

LOAD [Outage date],

     [outage id],

     [outage regions],

     SubField([outage regions],',')As Spl

FROM

[..\..\Downloads\Prod.xlsx]

(ooxml, embedded labels, table is Sheet2);

Not applicable
Author

Thanks . Technically it works. I tested it.  I am yet to join with look table that have unique list of regions.

but will it not increase load on Server?

I checked following forum that it will increase number of rows while loading though it helps to achieve desired functionality

The Secret Life of SubField

Anonymous
Not applicable
Author

Hi

i read the given forum

If more than one table having reign means you can load separate table using resident load and concatenate function

if we use this only two column value table  repeat the date this may reduce the performance compare to original fact table

Not applicable
Author

Thanks

Still i want load only single record per each row in source data. In real scenario i have 6 or 7 comma delimited fields where i will search using different filters.

I am searching in another forum and tried  concept of using variables .   But it needs input box and button for action.  I would like have the same functionality using List box will unique list of values

Comma separated searches | Qlik Community

jagannalla
Partner - Specialist III
Partner - Specialist III

Hope this helps you

Table1:

LOAD

[Outage Date],

[Outage Id],

[Outage Region]

From <>; 

Table2:       

Load Distinct

[Outage Region],

SubField([Outage Region], ',') as [Spl_Outage Region]

Resident Table1;