3 Replies Latest reply: Aug 29, 2014 4:40 AM by Agis Kalogiannis RSS

    **URGENT ASSISTANCE REQD** Cross tab function

    Chris Benham

      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