Lets say i have the following data:
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.
Sure you can use "group by" in QV script. Assuming your data is in table "Table", it would be:
LEFT JOIN (Table) LOAD DISTINCT
min(AppStart) as FirstTimeByDayRoom
GROUP BY Day, Room;
PS: As for the line graph - I'm not sure what exactly you want to show.
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.
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
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().