Help flagging minimum date (script below) - need urgent help

[#1]

Hello,

I've been wrestling with this for days after a deadline - and cannot figure out a solution though I think it's probably simple.

I want to show the following:

1. All data included in "Raw" (below)

2. Flag the minimum datetime

3. Add a conditional statement that states if the PIR (pt in room) was between 6:55 and 8:35 a.m.

What I'm getting currently with PEEK function is flagging all the PIR times as 1 instead of just the min time.

Much appreciation!

SET DateFormat='MM/DD/YYYY';

SET TimestampFormat='MM/DD/YYYY hh:mm';

Raw:

LOAD * INLINE [

    Date, Room, SURGEON, Sched_Start, PIR

    11/21/2014, 1, Dr B, 11/21/2014 08:00, 11/21/2014 08:00

    11/21/2014, 2, Dr B, 11/21/2014 08:00, 11/21/2014 07:50

    11/21/2014, 3, Dr B, 11/21/2014 08:00, 11/21/2014 07:00

    11/21/2014, 4, Dr C, 11/21/2014 08:00, 11/21/2014 07:02

    11/21/2014, 5, Dr C, 11/21/2014 08:00, 11/21/2014 07:56

];

Data:

LOAD

Date,

Room,

SURGEON,

Sched_Start,

PIR,

If(Peek(PIR) <> PIR, 1, 0) AS Flag

RESIDENT Raw

ORDER BY SURGEON DESC;

[#2]

Hi Giacomo,

Thanks so much - this may be easier for me to integrate than the other which I'm too much of a newbie to make work correctly in the current load script.

One question - it's now just showing the first cases as below even though I have set the condition as 0...do you know what I'm doing incorrectly?

Date	SURGEON	Room	PIR	Min_TIR
11/21/2014	Dr B	3	11/21/2014 07:00	1
11/21/2014	Dr C	4	11/21/2014 07:02	1

[#3]

Hi Giacomo,

Could you possibly send me your qv file so I may compare to the one I have?

Thank you so much for your help!

[giacomom]

Hi Karen,

sorry for my late response. How can I attach the file?

Giacomo

[anbu1984]

Click "Use Advanced Editor". Then click Attach

[giacomom]

Hi Karen,

here it is my qvw file.

(Thanks anbu cheliyan, I was answering from the Inbox and the advanced editor was disabled).

Giacomo

[#7]

Hi Giacomo,

Thank you very much; apologies for late response have been in a Kaizen Event all week.

I cannot see the attached file; could I trouble you to re-attach?

Appreciate your help!

[anbu1984]

I can see the file. Attaching Giacomo's QVW

[#9]

Hi Anbu,

For some reason I cannot download the file.

Are you able to send to me at karen.wallace@health-first.org?

Appreciate your help!

Thank you,

Karen

Karen Wallace, MPH

Sr. Decision Support Analyst

Analytics & Business Intelligence

Health First, Inc.

3300 Fiske Blvd.

Rockledge, FL 32955

Office: 321-434-6637

E-Mail: Karen.Wallace@Health-First.org

>>> anbu cheliyan <qcwebmaster@qlikview.com> 12/4/2014 7:50 AM >>>

Qlik Community ( http://community.qlik.com/ )

Re: Help flagging minimum date (script below) - need urgent help

reply from anbu cheliyan (

http://community.qlik.com/people/anbu1984?et=watches.email.thread ) in

New to QlikView - View the full discussion (

http://community.qlik.com/message/672662?et=watches.email.thread#672662

)

I can see the file. Attaching Giacomo's QVW

Reply to this message by replying to this email, or go to the message

on Qlik Community (

http://community.qlik.com/message/672662?et=watches.email.thread#672662

)

Start a new discussion in New to QlikView by email (

mailto:discussions-community-discussionforums-newto--qlikview@qliktech-public.hosted.jivesoftware.com

) or at Qlik Community (

http://community.qlik.com/choose-container.jspa?contentType=1&containerType=14&container=2003&et=watches.email.thread

)

Following Re: Help flagging minimum date (script below) - need urgent

help (

http://community.qlik.com/message/672662?et=watches.email.thread#672662

) in these streams: Inbox

© 1993-2014 QlikTech International AB Copyright & Trademarks (

http://www.qlikview.com/us/info/copyright ) | Privacy (

http://www.qlikview.com/us/info/privacy ) | Terms of Use (

http://www.qlikview.com/us/info/terms-of-use ) | Software EULA (

http://www.qlikview.com/us/info/software-eula )

#####################################

This message is for the named person's use only. It may

contain private, proprietary, or legally privileged information.

No privilege is waived or lost by any mistransmission. If you

receive this message in error, please immediately delete it and

all copies of it from your system, destroy any hard copies of it,

and notify the sender. You must not, directly or indirectly, use,

disclose, distribute, print, or copy any part of this message if you

are not the intended recipient. Health First reserves the right to

monitor all e-mail communications through its networks. Any views

or opinions expressed in this message are solely those of the

individual sender, except (1) where the message states such views

or opinions are on behalf of a particular entity; and (2) the sender

is authorized by the entity to give such views or opinions.

[anbu1984]

Emailed QVW to your mail id