Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner - Creator
Partner - Creator

on a selected date range , how to find the following ?

hi

i have the following table

IDDateTicket TypeStatus





00101-Jan-2016Aopen
00202-Jan-2016Bopen
00306-Jan-2016Aopen
00105-Jan-2016Aclosed
00601-Feb-2016Dopen
00702-Mar-2016Bopen

on the selected date range in what

Number of "open" tickets ,

Number of "closed" ,

Number of tickets closed within month (ie ticket raised in a month is closed in the same month)

For example

form the above table , if i select 1-Jan-2016 to 30-Jan-2016

Number of open tickets:- 2

Number of closed tickets :- 1

Number of tickets closed within that month :- 1

i want to show in table and also in KPI

can anyone help me?

1 Reply
lakshmikandh
Specialist II
Specialist II

Number of "open" tickets , - count (distinct if(Match(Status,'Open'),ID))

Number of "closed" , - count (distinct if(Match(Status,'Closed'),ID))

Number of tickets closed within month (ie ticket raised in a month is closed in the same month)

sum(aggr (

if( interval( if(Match(Status,'Closed'),Date) - if(Match(Status,'Open'),Date) ,'D') <=30, 1 , 0),

ID))