QlikView App Dev

Report Inappropriate Content · ‎2011-07-29

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?

rwunderlich · ‎2011-07-29

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

Report Inappropriate Content · ‎2011-07-29

hi,

use the date format MM/DD/YYYY

Sumit

Report Inappropriate Content · ‎2011-07-29

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

Report Inappropriate Content · ‎2011-07-29

Hi,

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

Regards!

Report Inappropriate Content · ‎2011-07-29

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

Report Inappropriate Content · ‎2011-07-29

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

Report Inappropriate Content · ‎2011-07-29

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

Report Inappropriate Content · ‎2011-07-29

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

Report Inappropriate Content · ‎2011-07-29

hi,

try this on your dimesion

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

It's working.

Sumit

Report Inappropriate Content · ‎2011-07-29

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.