topic Re: Group by function in QlikView

Group by function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

I want to group worked hours of an employee by month wise. But I'm having data as in the screenshot below, the table has multiple worked hours for an employee for a single or same date.

In this case when I use group by function in script, all the worked hours for a single date is not getting added and also I have used Month(Floor(Sheet_date), it is adding the worked hours which are unique to a single date but not the same values. Plz help me to do this...

I have also attached the sample excel sheet.

Re: Group by function

PrashantSangle — Tue, 07 Mar 2017 05:44:07 GMT

Hi,

can you attached your required output also???

Regards,

Prashant

Re: Group by function

Anonymous — Tue, 07 Mar 2017 05:57:23 GMT

In this output, I'm getting correct data for the date '02/02/2017' - (3+5=8) but for the date '02/03/2017' it is showing wrongly as 4, but it has to show (4+4=8)..

Re: Group by function

PrashantSangle — Tue, 07 Mar 2017 06:01:42 GMT

Hi,

Try sum(aggr(sum(Worked_hours),resource_id))

Regards,

Prashant

Re: Group by function

Anonymous — Tue, 07 Mar 2017 06:06:01 GMT

This can be used as an expression or can I use it in script.. I used this as an expression, but not working.

Re: Group by function

PrashantSangle — Tue, 07 Mar 2017 06:15:00 GMT

Hi,

Use as expression

instead of sum(Worked_hours)

updated expression,

sum(aggr(sum(Worked_hours),resource_id,proj_timesheet_id))

Regards,

Prashant

Re: Group by function

Anonymous — Tue, 07 Mar 2017 06:21:29 GMT

Thanks. but it's not working bro... I have tried it, Plz say if any other way to do.

Re: Group by function

PrashantSangle — Tue, 07 Mar 2017 06:38:25 GMT

Hi,

Can you share your app???

Regards,

Prashant Sangle