topic Re: Average hours per week in QlikView

Average hours per week

Tue, 22 Dec 2015 10:27:04 GMT

Hi All

I am new to qlikview, could you please help me in calculating Number of hours per week .

Pls see the attached excel file with pivot table

Re: Average hours per week

sunny_talwar — Tue, 22 Dec 2015 10:40:24 GMT

Is this an extract from QlikView or is this the way your data is structured?

Re: Average hours per week

jyothish8807 — Tue, 22 Dec 2015 10:44:07 GMT

Hi Ganesh,

PFA app. Hope it will be helpful.

CrossTable(Week, Data)

LOAD [Row Labels],

[1],

[2],

[3],

[4],

[5],

[6],

[7],

[8],

[9],

[10],

[11],

[12],

[13],

[14],

[15],

[16],

[17],

[18],

[19],

[20],

[21],

[22],

[23],

[24],

[25],

[26],

[27],

[28],

[29],

[30],

[31],

[32],

[33],

[34],

[35],

[36],

[37],

[38],

[39],

[40],

[41],

[42],

[43],

[44],

[45],

[46],

[47],

[48],

[Week Number],

[(blank)],

[Grand Total]

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Regards

Re: Average hours per week

Tue, 22 Dec 2015 10:46:44 GMT

HI sir, Thanks for quick reply

That is my data in excel file

Re: Average hours per week

jyothish8807 — Tue, 22 Dec 2015 10:54:37 GMT

You can remove from the script, its just an sample.

[Week Number],

[(blank)],

[Grand Total]

Regards

Re: Average hours per week

Tue, 22 Dec 2015 11:05:32 GMT

@KC

Hi Sir, Thanks for the response

could you please see the qvw file i have attached,

I am unable to grasp that i need from your file

Re: Average hours per week

Kushal_Chawda — Tue, 22 Dec 2015 11:31:41 GMT

Data:

CrossTable(WeekNumber1, Hours1,1)

LOAD [Row Labels] as Employee,

[1.000000],

[2.000000],

[3.000000],

[4.000000],

[5.000000],

[6.000000],

[7.000000],

[8.000000],

[9.000000],

[10.000000],

[11.000000],

[12.000000],

[13.000000],

[14.000000],

[15.000000],

[16.000000],

[17.000000],

[18.000000],

[19.000000],

[20.000000],

[21.000000],

[22.000000],

[23.000000],

[24.000000],

[25.000000],

[26.000000],

[27.000000],

[28.000000],

[29.000000],

[30.000000],

[31.000000],

[32.000000],

[33.000000],

[34.000000],

[35.000000],

[36.000000],

[37.000000],

[38.000000],

[39.000000],

[40.000000],

[41.000000],

[42.000000],

[43.000000],

[44.000000],

[45.000000],

[46.000000],

[47.000000],

[48.000000]

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1, filters(

Remove(Row, Pos(Top, 30)),

Remove(Row, Pos(Top, 29))

));

New:

NoConcatenate

LOAD Employee,

floor(trim(WeekNumber1)) as WeekNumber,

floor(trim(Hours1)) as Hours

Resident Data;

DROP Table Data;

Re: Average hours per week

jyothish8807 — Tue, 22 Dec 2015 12:48:42 GMT

Hi Ganesh,

Which sheet do you want to load in QV ? I can see you are using other 2 sheets right now.

Regards

Re: Average hours per week

Tue, 22 Dec 2015 12:51:24 GMT

Hi sir

Problem solved.

Thanks for the responses

Re: Average hours per week

oknotsen — Tue, 22 Dec 2015 12:55:42 GMT

If your question is answered, please flag a Correct Answer and optionally one or more Helpful Answers to "close" the topic.