exclude comment in filter

[mg862925]

I want to create a filter for comment section

Yes -Include only "Burn and discoloration on lcd,"

No -  Exclude all the "Burn and discoloration on lcd"

See my file

Best regard

Mikael

[Vegar · Accepted solution]

Please see attached Qlik Sense application file.

[mg862925]

Do I do this in Dataimport? (I get a failure right now)

[anushree1]

Please check if the attached file works for you

[anushree1]

Please check if the attached file works for you

[Vegar]

@mg862925  Yes you can do this in the data importer as I did in my example, but you can also do it your self  in the script editor like in the script below.

[Qlikforum]:
LOAD
  [InspectionComments],
  if( match([InspectionComments],'Burn-ins and discoloration on LCD.'),
      'Yes','No') AS [Exclude comments  (case sensitive)],
  if( wildmatch([InspectionComments], 'BuRn-InS aNd DiScOlOrAtIoN oN LcD.'),
      'Yes','No') AS [Exclude comment (case insensitive)],
  if( wildmatch([InspectionComments], 'Burn-ins and discoloration*', 'Airbubble*'),
      'Yes','No') AS [Exclude comment (wildchar and case insensitive)]
FROM 
    [lib://Downloads/qlikforum.xlsx]
    (ooxml, embedded labels, table is Sheet1);