Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...;
Could anyone help me with this?
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...;
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..
It worked, Changed the names to the wildcard, I was wrong, thanks Gysbert Wagenaar.