Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
chandashok
Contributor III

Re: Show all of pivot 2nd dimension

Hi

     Hope the attached qv file will be helpful for your requirement

Regards

Ashok

Not applicable

Show all of pivot 2nd dimension

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
Valued Contributor

Re: Show all of pivot 2nd dimension

Hi,

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

Regards,

Iyyappan

Not applicable

Show all of pivot 2nd dimension

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

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

v_iyyappan
Valued Contributor

Re: Show all of pivot 2nd dimension

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
Contributor

Re: Show all of pivot 2nd dimension

Hi all,

Have you solved the problem

Please, share the solution.

Many thanks

Emteam

Community Browser