IF statement for condensing dropdown list

[dnt503]

I currently have 4 different types of statuses in the status drop-down list. I want to just show only two options (Open & Closed). All the statuses (In progress, Scheduled with Client) I want labeled under the 'Open' option. I've created the IF statement below but it's not capturing the data correctly. Any help is appreciated. Thank you

Current Status list: In Progress, Closed, Open, Schedule with Client

Proposed status list: Open, Closed

Script:

line 1: STATUS_C as [Status],
line 2: if([STATUS_C]= 'Closed', 'Closed', 'In progress' 'Scheduled with Client' 'Open') as [Status Flag],

[MatheusC]

@dnt503 

Try this, with the Wildmatch function, see more details about the function in qlik help:

If(Wildmatch('In progress','Scheduled with Client'),'Open','Closed') as [Status Flag]

https://help.qlik.com/pt-BR/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...

Regarts, Matheus

[JustinDallas · Accepted solution]

if(Match([STATUS_C], 'In progress', Scheduled with Client'), 'Open, 'Closed') as [Status Flag]

[dnt503]

I just tried and it only gave me the 'Closed' option in the drop down list...

[BrunPierre]

Perhaps,

If(WildMatch(Status,'*Closed*'), 'Closed', 'Open') as "Status Flag"

[MatheusC]

I ended up forgetting to add the field [STATUS_C] to call the values 😅. @JustinDallas  sent the complete code.

Thanks!