This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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.
View solution in original post
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 FirstTimeByDayRoomFROM TableGROUP BY Day, Room;
Regards,MichaelPS: 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
please find the attachment below.
Please let me know if i did any wrong
Thx that worked.
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().