Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QlikExperts,
I am new to Qlik Sense.
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 ...!
TransactionNo | TransactionStatus | StatusCompletion | TotalTimeDifference in minutes [Transaction at E - Transaction at A] | Statndard Query used for Displaying in Qlik reports |
IND00123 | Transaction at A(Begin Status) | 2018-03-20 00:09:10 | 61 minutes | Currently we are displaying the standard output as below if the total difference is |
Transaction at B | 2018-03-20 00:09:12 | |||
Transaction at C | 2018-03-20 00:09:13 | |||
Transaction at D | 2018-03-20 00:09:14 | |||
Transaction at E(End Status) | 2018-03-20 01:10:03 |
Below is the Qlik Query Used:
Load *,
if(isnull(timedifference),'Not Applicable',if(timedifference <=5 ,'00-05 mins',
if(timedifference >5and timedifference <=10, '06-10 mins',
if(timedifference >10 and timedifference <=15, '11-15 mins',
'>15 mins','Above an hour')))) as TotalTAT
Resident TableName;
Hi Disnesh, one option can be using an extension for the user to input the desired step value, ie:
And you can use this variable value as:
Load *,
if(isnull(timedifference),'Not Applicable', // No value
if(timedifference > $(VariableName)*3, '>' & ($(VariableName)*3) & ' mins', // Above max
Replace(class(timedifference, $(variableName)), '<= x <', '-') & ' mins' // Buckets
)) as TotalTAT
Resident TableName;
Thanks Ruben.
We will on this option.