topic Re: Grouping data within a list prior to loading in QlikView https://community.qlik.com/t5/QlikView/Grouping-data-within-a-list-prior-to-loading/m-p/1322621#M834461 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(WildMatch([Booking Status], 'Confirmed*'),'Confirmed', 'Cancelled') as [Booking Status],</STRONG></P></BODY></HTML> Tue, 06 Jun 2017 19:31:58 GMT sunny_talwar 2017-06-06T19:31:58Z Grouping data within a list prior to loading https://community.qlik.com/t5/QlikView/Grouping-data-within-a-list-prior-to-loading/m-p/1322620#M834460 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>I've used <SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Booking Status]</SPAN><SPAN style="font-size: 8pt;">='Confirmed' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">or</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Booking Status]</SPAN><SPAN style="font-size: 8pt;">='Confirmed Do Not Move' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">or</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Booking Status]</SPAN><SPAN style="font-size: 8pt;">='Confirmed Internal' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">or</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Booking Status]</SPAN><SPAN style="font-size: 8pt;">='Confirmed Web Reservation','Confirmed', </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Booking Status]</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Booking Status]</SPAN><SPAN style="font-size: 8pt;">,</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">What syntax can I use to do the same for all cancellation types in the same list Booking Status?</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Grouping-data-within-a-list-prior-to-loading/m-p/1322620#M834460 2020-11-25T16:16:04Z Re: Grouping data within a list prior to loading https://community.qlik.com/t5/QlikView/Grouping-data-within-a-list-prior-to-loading/m-p/1322621#M834461 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(WildMatch([Booking Status], 'Confirmed*'),'Confirmed', 'Cancelled') as [Booking Status],</STRONG></P></BODY></HTML> Tue, 06 Jun 2017 19:31:58 GMT https://community.qlik.com/t5/QlikView/Grouping-data-within-a-list-prior-to-loading/m-p/1322621#M834461 sunny_talwar 2017-06-06T19:31:58Z Re: Grouping data within a list prior to loading https://community.qlik.com/t5/QlikView/Grouping-data-within-a-list-prior-to-loading/m-p/1322622#M834462 <HTML><HEAD></HEAD><BODY><P>Thank you so much for the quick suggestion!</P></BODY></HTML> Tue, 06 Jun 2017 19:39:48 GMT https://community.qlik.com/t5/QlikView/Grouping-data-within-a-list-prior-to-loading/m-p/1322622#M834462 2017-06-06T19:39:48Z