Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

First time of day by room

Hi,

Lets say i have the following data:

DayRoomPatientRegisteredAppStartAppEnd
AppID
8/1/2013A07:0707:1507:451
8/1/2013A07:5107:5508:102
8/1/2013B07:1507:2007:253
8/1/2013B07:3007:3507:454
8/2/2013A08:0508:1008:405
8/2/2013A07:3007:3507:506
8/2/2013B08:1508:3008:407
8/2/2013B08:4008:5009:108

I want to create a line graph that shows by day the first times of the day by room. Purpose is to monitor if appointments and registration started on time.

I did see that it is possible to load the data again grouped by the day and room, but was wondering is it is possible in the Qlikview document also.

Any help would be appreciated.

Robbert

1 Solution

Accepted Solutions
mov
Champion III
Champion III

The front end analog of the "group by" is the aggr() function, as in:

aggr(min(AppStart), Day, Room)

Could be more helpful if you uploaded the application.

Regards,

Michael

View solution in original post

7 Replies
mov
Champion III
Champion III

Robbert,

Sure you can use "group by" in QV script.  Assuming your data is in table "Table", it would be:

LEFT JOIN (Table) LOAD DISTINCT
Day,
Room,
min(AppStart) as FirstTimeByDayRoom
FROM Table
GROUP BY Day, Room;

Regards,
Michael
PS: As for the line graph - I'm not sure what exactly you want to show.

Not applicable
Author

Hi Michael,

What i want to do is create a graph in the Qlikview document and use a function in side the graph to accomplish the samething without loading in script.

Regards

Robbert

chematos
Specialist II
Specialist II

You could use an expression with aggr() function in the object of your document.

aggr() is like a group by, this is an example:

aggr(min(Time),Room, Day) where, Room and Day would be the fields of the group by group by.

Hope this helps

mov
Champion III
Champion III

The front end analog of the "group by" is the aggr() function, as in:

aggr(min(AppStart), Day, Room)

Could be more helpful if you uploaded the application.

Regards,

Michael

View solution in original post

shaik_basha
Creator III
Creator III

hi,

please find the attachment below.

Please let me know if i did any wrong

Thanks

Shaik

Not applicable
Author

Hi Michael,

Thx that worked.

Regards

Robbert

mov
Champion III
Champion III

This is correct.

If fields (Room and Day) are used as dimensions, the expressions are aggregated by these dimensions automatically, and there is no need for any aggr().

Regards,

Michael