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 :
Date(floor([Created])) AS Created_Date,
[Termination date] - Date(floor([Created])) AS Time_Laps
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.