Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to QlikView and hoping someone might be able to help. I have a list "Booking Status" that has multiple Confirmation and Cancellation types, and I'm trying to simply the list and group all the different confirmation types as 'Confirmed' and same with 'Cancelled' through the script.
I've used If ([Booking Status]='Confirmed' or [Booking Status]='Confirmed Do Not Move' or [Booking Status]='Confirmed Internal' or [Booking Status]='Confirmed Web Reservation','Confirmed', [Booking Status]) as [Booking Status],
What syntax can I use to do the same for all cancellation types in the same list Booking Status?
May be this
If(WildMatch([Booking Status], 'Confirmed*'),'Confirmed', 'Cancelled') as [Booking Status],
May be this
If(WildMatch([Booking Status], 'Confirmed*'),'Confirmed', 'Cancelled') as [Booking Status],
Thank you so much for the quick suggestion!