Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
atlantis_shahri
Contributor III
Contributor III

Reverse pivoting

Hey guys I'm having problem to achieve this. I have 5 columns ID,Product,Section, Sales,qty. I want Section Column values as a row.

Can anyone help me with this?  Thanks in advance

Untitled.png





2 Replies
Anil_Babu_Samineni

Are you doing in script / Front end. If it front end you can drag your column to row and use 2 expressions like Sales, Qty ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
shraddha_g
Partner - Master III
Partner - Master III

In Qliksense,

Use Pivot Table Chart,

In Rows,  Use ID and Product Fields

In Columns, Use Section Field.

In Measures Section Use Sales Expression and Qty Expression