Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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