Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
gauravgg
Contributor

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
Valued Contributor II

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

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))

Community Browser