4 Replies Latest reply: Aug 22, 2017 5:53 AM by Vineeth Pujari RSS

    Choosing several specific booking companies

    Madeleine Josefsson

      Hello,

      I have the following dataload:

      [Assignment]:

      LOAD

      [BookingDate],

      [SalesPerson],

      [AlfaCompany],

      [AssignmentNumber],

          [AssignmentNumber] as InvoiceLink,

      [AssignmentType],

      [BookingCompany],

          [BookingCompanyName],

      [OpenOrClosed],

      [Assignee],

      [OriginCity],

      [OriginCountryCode],

      [DestinationCity],

      [DestinationCountryCode],

      [LoadingDate],

          Year (LoadingDate) as LoadingYear,

          Month (LoadingDate) as LoadingMonth,

      [UnloadingDate],

          [SurveyDate],

      [Volume],

      [PriceCompanyCurrency],

      [MoveManager]

       

      FROM [lib://QvdLib (alfa_qliksense)/Prod\Load\AlfaAssist.qvd]

      (qvd)WHERE [BookingDate]> makedate(2015)AND match([BookingCompany],'12487')

       

      How can I write to pick several Booking companies? I.e I want the report to show data on more than customer 12487.

       

      Thanks!