Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cann't get the Days to "Group By"

I have a simple grapgh that I want to create. Total hours by day in a Bar Chart.  However this is not how granualar the data is.  My data set goes to the task level meaning I have multiplule taskes per day that I need to aggrigate together to get a total hour number for the day.

In my dimensions tab i have a calculated dimesnion of StartDate so that I can format the data into a M/DD/YYYY output.  In my expresions I have sum(totalHours)

This graph does not sum a full day, it still shows me the sum of the indifidual tasks per day.  What am I doing wrong?

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Date is a formatting function, it does not remove the time value from the internal value used for grouping. Use the floor() function to extract only the integer -- the date -- portion.

=DATE(floor(StartTime), 'M/D/YYYY')

-Rob

http://robwunderlich.com

View solution in original post

13 Replies
Not applicable
Author

hi,

use the date format MM/DD/YYYY

Sumit

Not applicable
Author

I started with it that way.  No difference.  It still will not group by day and sum total hours

Not applicable
Author

Hi,

Try ussing aggr(sum(totalHours), StartDate), or you can upload an example qvw so that we can help you better.

Regards!

Not applicable
Author

I just treid your suggetion, and got one column, not one column per day...attached is the doc

Not applicable
Author

I'm sorry I can't see the attached doc

Not applicable
Author

From: Gabriela Morales

Sent: Friday, July 29, 2011 10:50 AM

To: Dionne, James

Subject: - Re: Cann't get the Days to "Group By"

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Cann't get the Days to "Group By"

created by Gabriela Morales<http://community.qlik.com/people/gabymorales> in New to QlikView - View the full discussion<http://community.qlik.com/message/136986#136986

Not applicable
Author

Im trying to use the advanced editor to get this uploaed...let me know if it gets there this time.

Not applicable
Author

hi,

try this on your dimesion

date(StartTime, 'MM/DD/YYYY')

It's working.

Sumit

Not applicable
Author

I still have multiple lines per day when I only want one line per day. This is in the second bar chart at the bottom where I need this.