Qlikview Script

[#1]

Hello everyone,

LOAD *,
1 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] ??

[#2]

ok cool, it works. I am using Ticket Age as a dimension to plot on Qlikmaps. Thanks a lot Antonio

[qlikviewwizard]

USe Ticket State as [Ticket State]. You missed [ ]. Hope this will helps you.