We had come with a below requirement. we don't know how to achieve this.
Kindly help in achieving this result.
Below is the table for the scenario.
Here we have calculated the TotalTimeDifference against each transaction status.
But currently we are defining only the defined slabs[of 5 minutes interval] in Qlik ETL Queries as below.
If time difference is between 00-05 then it will display 00-05 mins, if between 06-10 then 06-10 mins and so on as below.
But the requirement is that user should pass some dynamic values, if they pass somewhere 10 then time difference should be calculated based on 10 minutes interval, Also Column names should change accordingly like
00-10 mins,11-20 mins,21-30 mins and >30 mins
Please help in achieving this result.
Thanks in Advance ...!
TotalTimeDifference in minutes [Transaction at E - Transaction at A]
Statndard Query used for Displaying in Qlik reports
Transaction at A(Begin Status)
Currently we are displaying the standard output as below
if the total difference is Less than 5 then -- 00 -05 mins Between 5 to 10-- 05- 10 mins Between 11 to 15-- 11- 15 mins Greter than 15 -- > 15 minutes