pivot table dimension in every line

[Anonymous]

Hello,

i need in the product column in every line the product. It`s a pivot table.

It`s should like look this pivot: (A straight table is not the solution)

THANKS

[MK_QSL]

Change Pivot Table to Straight Table.. This is the only direct solution....

[#3]

Hi QlikViewSE,

As @Manish Kachhia said ....changing from pivot table to a staright table is the most simplest and effective option.

But if you need product name on every row you could try out the solution that i am attaching.

I have displayed the product name on every row by creating an expression.

Go through the same.

Hope it helps.:)

[#4]

Hi QlikViewSE,

There is no direct way to achieve the above chart using Pivot table but you can use some trick of AGGR and DUAL Function in Calculated Dimension to achieve the same (=AGGR(DUAL(Product,RowNo()),[Part Number])).

Regards

Nandkishor Pandirkar

[Anonymous]

Why is a straight table not a viable solution ?