Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
erric3210
Creator
Creator

Need to Transpose Horizontal Columns to vertical Rows in Pivot Table

Hi Experts,

I've a requirement to Transpose & convert Horizontal Columns to vertical Rows in Pivot Table.

See this:

Community_2.png

Here is the sample data:

Name State Salary Status
Neil New Jersey 200000 Permanent
Neil California 70000 Contract
Ash Texas 0 Contract
Ash New York 300000 Permanent

 

Need your suggestions & help.

Regards,

Eric

Labels (1)
4 Replies
salonicdk28
Creator II
Creator II

Use CrossTable Load- The Crosstable Load

Thanks,

Saloni

erric3210
Creator
Creator
Author

hi @salonicdk28 

Thanks for replying but this is now what i'm expecting.

I want to make change in front end Pivot table chart.

Is there any way. I tried Valuelist and pass the expressions.

Regards,

Eric

erric3210
Creator
Creator
Author

Does anyone has answer to this scenario.

vinieme12
Champion III
Champion III

That is not possible, it is how the visualization is created

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.