11 Replies Latest reply: Jul 31, 2015 8:47 PM by arjun rao RSS

    Qlikview Script

      Hello everyone,

      LOAD *,
      as Counter,

      [Ticket Number] as TicketNumberKey, // key filed to link SLA table

        if ([Ticket Type]='Incident',1,0) as [CounterIncident],

      if ([Ticket Type]='Catalog Task',1,0) as [CounterTask]


      I want to declare a filter using the field [Ticket Type] after the above three lines. As I have renamed it to [Counterincident] and [CounterTask] based on the stages, how do I use the field [Ticket Type] ??