topic Re: Show all of pivot 2nd dimension in QlikView

Show all of pivot 2nd dimension

Thu, 01 Mar 2012 06:38:14 GMT

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

Re: Show all of pivot 2nd dimension

Anonymous — Thu, 01 Mar 2012 06:46:04 GMT

Hope the attached qv file will be helpful for your requirement

Regards

Ashok

Show all of pivot 2nd dimension

Thu, 01 Mar 2012 06:54:46 GMT

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

Re: Show all of pivot 2nd dimension

v_iyyappan — Thu, 01 Mar 2012 07:35:01 GMT

Hi,

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

Regards,

Iyyappan

Show all of pivot 2nd dimension

Thu, 01 Mar 2012 07:39:31 GMT

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

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

Re: Show all of pivot 2nd dimension

v_iyyappan — Thu, 01 Mar 2012 07:55:22 GMT

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

Re: Show all of pivot 2nd dimension

emteam162 — Mon, 02 Dec 2013 23:57:08 GMT

Hi all,

Have you solved the problem

Please, share the solution.

Many thanks

Emteam