Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

exclude comment in filter

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: exclude comment in filter

Please see attached Qlik Sense application file.

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: exclude comment in filter

Please see attached Qlik Sense application file.

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

New Contributor

Re: exclude comment in filter

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

Highlighted
Valued Contributor II

Re: exclude comment in filter

Please check if the attached file works for you

Highlighted
Valued Contributor II

Re: exclude comment in filter

Please check if the attached file works for you

Highlighted
Partner
Partner

Re: exclude comment in filter

@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);

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes