4 Replies Latest reply: Nov 26, 2012 6:09 AM by duncankemmer RSS

    Loading a pivot table

      Hello,

       

      I'm working on a Qlikview dashboard for my company and I'm trying to load in a .xlsx file, a pivot table, with on the left side the record numbers and on top the dates. The data I want to load is the amount of hours in a month the person has worked. When I try to load it, Qlikview loads it as: Person, Date, Data. The Data however is the same for Date and Data. In the table files display, it does show the right way. Find the .xlsx attached to this post. The data in the .xlsx is from a larger excel file, but because of sensitive information I can't distribute the whole file.

       

      Many Thanks,

       

      Duncan