Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Creating Calendar

Hi guys.

There is the system where our customers ask questions. And we have to answer them during 4 working days. After we answer, customer closes the question if the answer has satisfied him. If customer does not close the question after we answered, question closes automatically in 3 days after Control Date is come.

The table contains al these information:

Question ID

Control Status (Control Date not come yet, Expired, Closed at Time)

Created Date

Control Date (create date + 4 working days)

Answered Date

Closed Date

 

So we have KPI, that calculated:

Quantity of closed questions answered until Control Date / (Quantity of closed questions + Quantity of opened and expired questions) 

For example,

I want to calculate KPI for 1Q'19. So it means that:

1. Quantity of questions [Created Date] <= 31.03.19 and [Closed date] >= 01.01.2019 and [Closed date] <= 31.03.19 and [Control status] = 'Closed at Time'

2. Quantity of questions [Created Date] <= 31.03.19 and [Closed date] >= 01.01.2019 and [Closed date] <= 31.03.19 

3.  Quantity of questions [Created Date] <= 31.03.19 and [Closed date] >= 01.01.2019 or [Closed date] = Null() and [Control status] = 'Expired'

KPI = 1/(2+3)

How can i create such calendar, where i can choose YEAR, QUATER, MONTH,DATE?

0 Replies