Pivot table Pivoting

Tue, 06 May 2014 15:10:04 GMT

Hi Experts,

Can a pivot table be arranged in the way I have depicted in the attached picture.

I have three dimension(as shown in red, in the picture)...Item Number, Product Number and Reason of Return.

Please suggest.

Thanks.

Re: Pivot table Pivoting

Tue, 06 May 2014 17:01:03 GMT

Hello Bikash:

One possibility to solve your situation is that you can create an inline table like this:

load * inline [

Dimension_Table , Reason to return (name of the fild in your table)

Product Number ,Bad

Product Number ,not working

Product Number ,the list of the all possibilities

Item Number ,the list of the all possibilities

Bad , Bad

not workling , not working

etc , et

];

Then is your pivot table you will choose Dimension_Table as your dimmension and the expresión will be something like this: If(Dimension_Table = Prodcut Number, only(Product Number),

If(Dimension_Table = ItemNumber, only(ItemNumber),

count(Reason to return))

Of course that you instead of making an inline table you could do it in an automatic way by linstin the reasons.

I hope It will be useful for you.

Regards,

Marcelo

topic Re: Pivot table Pivoting in QlikView

Pivot table Pivoting

Re: Pivot table Pivoting