Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
MiguelHathaway
Contributor II
Contributor II

Script not working with STARTS WITH function in Qlik Sense

I'm trying to load some tables using the script, in order to create new tables according to an IF condition.

My script is the following:     www.myallsaversconnect.com

LOAD Pippo
if(color = 'green', 'ok',
if(color = 'yellow' and text <> 'No control needed', 'check',
if(color = 'red' and text <> 'Control now', 'check', 'ok'))) as Pippo1

In the line with the color = yellow, I want to catch different cases because there are many text occurrences starting with 'No control needed' (for example No control needed (for 1 week), No control needed (for 2 weeks)), and I want to select them all.

I tried using: text<>'No control needed'*, but it did not work.

Any suggestions?

Labels (1)
0 Replies