Skip to main content
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Nemo1
Creator II

How to transpose information?

Hello everyone, 

 

So I have data in an excel represented like this: 

Nemo1_0-1723103576518.png

 

but i want to have it represented like this:

Nemo1_1-1723103595069.png

 

 

how can i do that with qlik sense? 

 

thanks!!

 

 

5 Replies
Kushal_Chawda

@Nemo1  Create pivot table like below.

1. Add Month to Column dimension

2. Create two measures for Sales & Cost as Sum(Sales) & Sum(Cost)

3. Drag Values to Row dimension as highlighted in screenshot

Screenshot 2024-08-08 at 11.58.27.png

Venkat7
Contributor II

use cross table in load editor

cross table 

Venkat7
Contributor II

use cross table 

Nemo1
Creator II
Author

that does not work 😞 

 

I get on top of my table this loupe , which is not what I am looking for. 

 

Nemo1_0-1723536432724.png

 

Nemo1
Creator II
Author

This is a better example of what I need to do. 

As input table I have this: 

Nemo1_1-1723537843496.png

 

The result I am aiming for is: 

Nemo1_2-1723537865355.png

 

I have read that i could do this with generic load but I have no idea how to do that. 

 

Any help is appreciated.