Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Grouping data within a list prior to loading

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?

1 Solution

Accepted Solutions
Highlighted

May be this

If(WildMatch([Booking Status], 'Confirmed*'),'Confirmed', 'Cancelled') as [Booking Status],

View solution in original post

2 Replies
Highlighted

May be this

If(WildMatch([Booking Status], 'Confirmed*'),'Confirmed', 'Cancelled') as [Booking Status],

View solution in original post

Highlighted
Not applicable

Thank you so much for the quick suggestion!