
Creator II
2024-08-08
03:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to transpose information?
Hello everyone,
So I have data in an excel represented like this:
but i want to have it represented like this:
how can i do that with qlik sense?
thanks!!
Labels (5)
Labels
- Subscribe by Topic:
-
Advanced Authoring
-
Client Managed
-
General Question
-
Not a Question
-
SaaS
5 Replies

MVP
2024-08-08
07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
454 Views

Contributor II
2024-08-08
09:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use cross table in load editor
cross table
439 Views

Contributor II
2024-08-08
09:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use cross table
439 Views

Creator II
2024-08-13
04:07 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
that does not work 😞
I get on top of my table this loupe , which is not what I am looking for.
386 Views

Creator II
2024-08-13
04:33 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is a better example of what I need to do.
As input table I have this:
The result I am aiming for is:
I have read that i could do this with generic load but I have no idea how to do that.
Any help is appreciated.
384 Views
