Discussion Board for collaboration on QlikView Layout & Visualizations.
Lets say I need a report on my clothes store sales.
I choose a pivot table and start with product category as my first dimension (shirt, t-shirts, sweaters and so on). As my second dimension I want size (S,M,L).
If I by any chance not sold any size M of a product category that row will not show.
How to accomplish that all, possible, sizes always shows for all product categories?
Attaching a simple example where I would like to see T-shirts, M, 0
Hope the attached qv file will be helpful for your requirement
Hi, no. Only difference is that if I select the T-shirt product I get a row that says -, 0
I'm thinking of calculating all possible outcome and where (pseudo) nbr>0=nbr else 0
I attached sample QV file. Hops its helpful for u.
No, still missing Size M for T-shirts...
I'm using QV 10 SR3 if that's maybe the issue?
I attached two Image for Your requirments .
1 . First one is whether u expect pivot table display the data like this.
2. Its correct means use the Second image .
Have you solved the problem
Please, share the solution.