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: 
sasudata
Contributor
Contributor

How To Filter Comma Separated Data

In worksheet, if cell contents are separated by commas, when you apply the Auto Filter utility, it only allows you to filter by the entire cell record. IF I want to create graphs for the counts of the unique value, then only columns with only unique value are selected and other columns (containing unique value of interest and other data separated by column) are not included. But I want those also in calculations. So how should i proceed.

Ex: Attached file

In Column B , If i want to have count of Cancer, then i need to have all cells counted where it is included as unique value and also along with other data (comma separated values). How Can i do this in qliksense, so that once i select "cancer", all columns containing that value will be pulled. 

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

e21e1519-c76e-4ae4-b182-b6b53665df9e.gif

LOAD [Owner Companies], 
     trim(Subfield(Indications,';')) as Indication, 
     Indications as [All indications],
     trim(Subfield([Target-based Actions], ';')) as [Target-based Actions],
     [Target-based Actions] as [All target-based Actions]
FROM
[https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/new-to-qlik-sense/130645/1/Sample.xls]
(biff, embedded labels, table is Results$);

View solution in original post

2 Replies
idogridish2
Creator II
Creator II

Hi,

you can create a flag in the script,

example:

LOAD
"Owner Companies",
Indications,
if(SubStringCount(Indications,'Cancer')>0 or SubStringCount(Indications,'cancer')>0,'Y','N') as Flag,
"Target-based Actions"
FROM [lib://Desktop/Sample.xls] (biff, embedded labels, table is Results$);

Vegar
MVP
MVP

e21e1519-c76e-4ae4-b182-b6b53665df9e.gif

LOAD [Owner Companies], 
     trim(Subfield(Indications,';')) as Indication, 
     Indications as [All indications],
     trim(Subfield([Target-based Actions], ';')) as [Target-based Actions],
     [Target-based Actions] as [All target-based Actions]
FROM
[https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/new-to-qlik-sense/130645/1/Sample.xls]
(biff, embedded labels, table is Results$);