Dimensions don't show in Pivot Table

[jolienjansen]

Hey all,

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? 

Thanks in advance.

Best wishes, Jolien

[miskinmaz · Accepted solution]

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

[jolienjansen]

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!