topic Re: Loading a pivot table in QlikView

Loading a pivot table

Mon, 26 Nov 2012 09:18:24 GMT

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

Re: Loading a pivot table

Mon, 26 Nov 2012 10:41:56 GMT

Could anyone help me with this?

Re: Loading a pivot table

Gysbert_Wassenaar — Mon, 26 Nov 2012 10:49:09 GMT

You can use the crosstable function. If you're using the table wizard select embedded labels under Labels.

Table1:

Crosstable(Date,Hours,1)

load * from etc...;

Re: Loading a pivot table

Mon, 26 Nov 2012 10:52:52 GMT

Thanks for your answer, I tried that, but it doesn't work.. The problem is then i get output like:

So I get Number, Date, Date.. instead of hours..

Re: Loading a pivot table

Mon, 26 Nov 2012 11:09:55 GMT

It worked, Changed the names to the wildcard, I was wrong, thanks Gysbert Wagenaar.