Finding Min Date

[#1]

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 )

[vinieme12]

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?

[#3]

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)

[vinieme12]

ok, got it, working on it

[#5]

Hi Vineeth got any solution?

[#6]

Any Solutions Plz

[vinieme12]

See attached, added some more lines to test further

[#8]

Thankyou I got the clue.

[vinieme12]

If the query is resolved, please close the thread

Qlik Community Tip: Marking Replies as Correct or Helpful