Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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$);
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$);
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$);