Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have the difficulty in Picking Date.
For WorkitemId 2790066 I need to pick Mintimestamp that is 10-10-2016 18:30:51 instead of 10-10-2016 17:02:18
(Note: For WorkitemId 2790066 there are 2 CHECKOUT continuously appeared need to pick max of this 2 checkouts as appeared continuously more than 2 or 3 times irrespective )
Sorry Vamsi, but your requirement is still unclear
Can you explain in a bit more detail what does this screenshot mean? also what is the condition that your are trying to flag in the script
Scenario 1- Pick Min date of Checkout?
Scenario 2- Pick Max date of Checkout if it appears consecutively?
As Shown in the Excel Pic,
Scenario1-
For Workitem 277585 the Start time should be 04-10-2016 14:53:39 because in
FromStatuscode it is NEW and
Event is CHECKOUT
Scenario2-
For Workitem 279066 the Start time should be 10-10-2016 18:30:51 because in
FromStatuscode it is NEW and
Event is CHECKOUT
(Pick Max date if seen multiple Checkouts Continuously)
ok, got it, working on it
Hi Vineeth got any solution?
Any Solutions Plz
See attached, added some more lines to test further
Thankyou I got the clue.
If the query is resolved, please close the thread
Qlik Community Tip: Marking Replies as Correct or Helpful