Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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?

Tags (3)
1 Solution

Accepted Solutions

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

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

13 Replies
Not applicable

Cann't get the Days to "Group By"

hi,

use the date format MM/DD/YYYY

Sumit

Not applicable

Cann't get the Days to "Group By"

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

Not applicable

Cann't get the Days to "Group By"

Hi,

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

Regards!

Not applicable

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

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

Not applicable

Cann't get the Days to "Group By"

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

Not applicable

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

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

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

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

Not applicable

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

hi,

try this on your dimesion

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

It's working.

Sumit

Not applicable

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

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.

Community Browser