Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do I do this in Dataimport? (I get a failure right now)
Please check if the attached file works for you
Please check if the attached file works for you
@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);