topic URGENT ASSISTANCE REQD Cross tab function in Qlik Learning Discussions

URGENT ASSISTANCE REQD Cross tab function

Thu, 28 Aug 2014 15:12:55 GMT

Hi guys,

Ok ive been using Qlikview for a little while now, so far so good.......I have come across a requirement for the import of an Excel sheet today, that I just cant get my head around.

I think the crosstab function is what I need - but don't seem to be able to get the right data coming through, nomatter what I try.

The problem (as per the attached) is that the layout of fields looks nice in Excel - but doesn't translate well at all into Qlikview. Im basically looking to replicate this sheet, but for week \ location & split by Rigs & operatives

If anyone can help with my load script, it would be greatly appreciated

apologies for the screenshot - the excel sheet contains links to other sheets & Im not permitted to share the entire sheet

Re: URGENT ASSISTANCE REQD Cross tab function

Agis-Kalogiannis — Thu, 28 Aug 2014 16:00:42 GMT

Hi Chris

In this example I had to replicate your excel file and load it twice for the two different tables, Operatives and Rigs.

Can you please have a look and let me know if this is what you're looking for?

Thanks

Agis

Re: URGENT ASSISTANCE REQD Cross tab function

Fri, 29 Aug 2014 06:19:46 GMT

Hi Agis,

Thats looking much better ! (thank you)......the only additional thing i can think that id need, is week number (apologies, theyre on the first row of the example, but are un-labelled)

is there a way of getting week number in there too ?

thank you very much again

Chris

Re: Re: URGENT ASSISTANCE REQD Cross tab function

Agis-Kalogiannis — Fri, 29 Aug 2014 08:40:50 GMT

Good morning Chris

I modified the script a little bit so as to give you the week numbers as well.

We don't need to load the numbers from the original xls file, since week numbers can be easily calculated, using the week() function.

If this is what you want, can you please mark the discussion as answered so as to close it?

Thank you

topic **URGENT ASSISTANCE REQD** Cross tab function in Qlik Learning Discussions

**URGENT ASSISTANCE REQD** Cross tab function

Re: **URGENT ASSISTANCE REQD** Cross tab function

Re: **URGENT ASSISTANCE REQD** Cross tab function

Re: Re: **URGENT ASSISTANCE REQD** Cross tab function

topic URGENT ASSISTANCE REQD Cross tab function in Qlik Learning Discussions

URGENT ASSISTANCE REQD Cross tab function

Re: URGENT ASSISTANCE REQD Cross tab function

Re: URGENT ASSISTANCE REQD Cross tab function

Re: Re: URGENT ASSISTANCE REQD Cross tab function