Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewse
Contributor
Contributor

pivot table dimension in every line

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

4 Replies
MK_QSL
MVP
MVP

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

Not applicable

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.:)

Not applicable

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

bill_markham
Champion III
Champion III

Why is a straight table not a viable solution ?