topic Re: Qlikview script in QlikView

Qlikview script

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

Guys,

I used the below code to group data by month wise,

But as the data contains multiple rows or values for a single date, I couldn't sum all the values of a month. Plz help me guys, attched my sample excel file..

Re: Qlikview script

Peter_Cammaert — Mon, 06 Mar 2017 16:41:19 GMT

Can you explain what data you're trying to put in table Hours0?

Re: Qlikview script

Anonymous — Tue, 07 Mar 2017 05:26:51 GMT

I want to get the worked hours of each employee by month wise

Re: Qlikview script

lyeynant — Wed, 17 Jan 2018 12:27:40 GMT

Hi Siva,

You need to change your script as -

Source:

LOAD ProjectID,

EmployeeID,

sheet_date,

Billable,

worked_hours,

Month(sheet_date)&Year(sheet_date) as MonthYear

From ...qvd (qvd);

Store Source Into ... Source.qvd ;

Drop Table Source;

Hours:

LOAD EmployeeID&MonthYear as key,

EmployeeID,

MonthYear,

Round(Sum(worked_hours)) as Monthly_WorkHours

From Source.qvd (qvd)

Group by EmployeeID,MonthYear ;

Left Join

LOAD EmployeeID&MonthYear as key,

Round(Sum(worked_hours)) as Monthly_BillableWorkHours

From Source.qvd (qvd)

Where Billable='true' ;

I didn't saw field billable in your xls, believe you have it in your DB.

Also you can use the first table and make the calculation in UI using set analysis.

Good luck!