I'm currently experimenting with my first Qlikview dashboard. I'm trying to create a pivot table that aggregates based on 1 dimension.
What I want my table to look like is:
Category
Amount
Broom
430
Laptop
84
Teddy
201
However, qlikview doesn't seem to recognise the dimension in my original table. When I try to create the pivot table that I want I'm getting this:
Category
Amount
-
715
For the data I have loaded an xlsx table into qlikview, and I am using that to build my pivot table. Am I missing something? Maybe I have to specifically tell qlikview what the dimensions are?
Just to debug where actually your problem is, you take Category as filter in your sheet and check if all your data is available. Once this is done try to design a simple table with a simple expression and category as dimension
Just to debug where actually your problem is, you take Category as filter in your sheet and check if all your data is available. Once this is done try to design a simple table with a simple expression and category as dimension
This was a good idea, this made me find out that my tables aren't joined correctly (both variables come from different tables. I will try to solve the joining problem now 🙂 Thanks for the help!
