topic Re: Picking Single Date considering (max or min) in QlikView

Finding Min Date

Wed, 04 Jan 2017 13:26:20 GMT

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 )

Re: Picking Single Date considering (max or min)

vinieme12 — Wed, 04 Jan 2017 14:35:24 GMT

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?

Re: Picking Single Date considering (max or min)

Wed, 04 Jan 2017 14:47:42 GMT

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)

Re: Picking Single Date considering (max or min)

vinieme12 — Wed, 04 Jan 2017 15:50:31 GMT

ok, got it, working on it

Re: Picking Single Date considering (max or min)

Thu, 05 Jan 2017 09:03:45 GMT

Hi Vineeth got any solution?

Re: Finding Min Date

Thu, 05 Jan 2017 14:05:53 GMT

Any Solutions Plz

Re: Finding Min Date

vinieme12 — Thu, 05 Jan 2017 15:21:47 GMT

See attached, added some more lines to test further

Re: Finding Min Date

Fri, 06 Jan 2017 09:48:10 GMT

Thankyou I got the clue.

Re: Finding Min Date

vinieme12 — Sun, 08 Jan 2017 13:04:53 GMT

If the query is resolved, please close the thread

Qlik Community Tip: Marking Replies as Correct or Helpful