Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] ??
ok cool, it works. I am using Ticket Age as a dimension to plot on Qlikmaps. Thanks a lot Antonio
USe Ticket State as [Ticket State]. You missed [ ]. Hope this will helps you.