Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show all of pivot 2nd dimension

Hi!

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

regards

thomas

6 Replies
Anonymous
Not applicable
Author

Hi

     Hope the attached qv file will be helpful for your requirement

Regards

Ashok

Not applicable
Author

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

v_iyyappan
Specialist
Specialist

Hi,

     I attached sample QV file. Hops its helpful for u.

Regards,

Iyyappan

Not applicable
Author

No, still missing Size M for T-shirts...

I'm using QV 10 SR3 if that's maybe the issue?

v_iyyappan
Specialist
Specialist

Hi,

      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 .

Regards,

Iyyappan

emteam162
Creator
Creator

Hi all,

Have you solved the problem

Please, share the solution.

Many thanks

Emteam