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
Creator
Creator

Output on the basis of status of a stage's timestamp

Hi All ,

 I have list of timestamps of various stages of contracts . Now my requirement is  I need to have the list of all the timestamps between only two stages  of any contract.Here :Stage1 is Request Credit Approval and Stage2 is Approved.

Input :                                                                                                                           

contract_idinput_dtStatus
1870412-07-2018 12:05RM Query
1870412-07-2018 12:07Request Credit Approval
1870412-07-2018 12:07Auto-Approved
1870412-07-2018 12:07PreSanct Doc Verification
1870412-07-2018 12:56RM Query
1870412-07-2018 12:56Correction Required
1870412-07-2018 13:00Approved
1870624-07-2018 10:54RM Query
1870624-07-2018 10:54Correction Required
1870624-07-2018 13:09Manual Approval Required
1870624-07-2018 13:09Qualify
1870624-07-2018 13:09Request Credit Approval
1870625-07-2018 09:21PreSanct Doc Verification
1870625-07-2018 09:21Correction Reply
1870625-07-2018 10:29CO Approval Required
1870625-07-2018 12:29Approved
1870625-07-2018 13:21RM Query
1870625-07-2018 13:21Correction Required

 

Output:

contract_idinput_dtStatus
1870412-07-2018 12:07Request Credit Approval
1870412-07-2018 12:07Auto-Approved
1870412-07-2018 12:07PreSanct Doc Verification
1870412-07-2018 12:56RM Query
1870412-07-2018 12:56Correction Required
1870412-07-2018 13:00Approved
1870624-07-2018 13:09Request Credit Approval
1870625-07-2018 09:21PreSanct Doc Verification
1870625-07-2018 09:21Correction Reply
1870625-07-2018 10:29CO Approval Required
1870625-07-2018 12:29Approved

 

Thanks in advance,

Ruma

2 Replies
Highlighted

Script / Design?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Creator

I need the script.