Calculating time duration in Quarters.

[Shafiqur_Khan]

Hello!

I am absolutely new to Qlik Sense. I was given this task : 'Display time elapsed between change request receipt (created) and decision taken (terminated) over time (in quarters)'.  And also I have to show the output in Bar chart. Now, I can show the substracted days in the bar chart. But i have to show them in quarter.

 To find out the time duration I did as below in the Data Load Editor :

Calculated_Values:
Load
  [Change ID],
  Date(floor([Created])) AS Created_Date,
  [Termination date] - Date(floor([Created])) AS Time_Laps
  
  
Resident Sheet1;

Bar Chart of the time lapse

but I don't know how to show the result in quarter. What to do?

My source file is a spreadsheet containing three columns : Change ID, Created and Termination Date.

Thank You

[treysmithdev · Accepted solution]

Try this:

Calculated_Values:
Load
  [Change ID],
  Date(floor([Created])) AS Created_Date,
  Month(Date(floor([Created]))) as Created_Month, 
 Dual('Q'&Ceil(Month(Date(floor([Created])))/3),Ceil(Month(Date(floor([Created])))/3)) as Created_Quarter,
  [Termination date] - Date(floor([Created])) AS Time_Laps
  
  
Resident Sheet1;

Then use [Created_Quarter] as a dimension in your chart.

[Shafiqur_Khan]

Thank you very much!! it worked perfectly!