topic Re: Group Table in QlikView

Group Table

Anonymous — Thu, 23 Jul 2015 06:47:35 GMT

I have a script which loads from different 4 different data sources. All of them are for data based on a weekly interval.

I also have some data which I want to load that is at daily interval, however the load crashes each time. and I don't get a script error.

I am sure there is way to load this in, possibly by grouping the table by week (and then linking), but I am not sure.

My table currently looks like below :

Staff_Number, DateOfShift, Reason,Hours_Worked, Cost_Of_Shift

I think I need to group my table so it loads as a group table below:

Staff Number, WeekEndDate, Reason, Hours_Worked, Cost_Of_Shift

If I am on the wrong path, please point me in the right direction, if not can you help with the above. Can anyone help.

Any help appreciated.

Phil

manojkulkarni — Thu, 23 Jul 2015 06:59:49 GMT

It will be more clear if you put some sample files. it can be any form.

Anonymous — Thu, 23 Jul 2015 07:44:30 GMT

I have added a spreadsheet

Kushal_Chawda — Thu, 23 Jul 2015 07:53:08 GMT

Please see the attached

Anonymous — Thu, 23 Jul 2015 08:19:37 GMT

I can easily group it in the report. I Need it to be grouped in the load script not in the report.

Regards

Phil

Kushal_Chawda — Fri, 24 Jul 2015 14:23:01 GMT

why you need it in load only?