topic Re: How to transpose information? in App Development

How to transpose information?

Nemo1 — Fri, 15 Nov 2024 20:53:49 GMT

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!!

Kushal_Chawda — Thu, 08 Aug 2024 11:02:28 GMT

@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

Venkat7 — Thu, 08 Aug 2024 13:38:59 GMT

use cross table in load editor

cross table

Venkat7 — Thu, 08 Aug 2024 13:39:32 GMT

use cross table

Nemo1 — Tue, 13 Aug 2024 08:07:27 GMT

that does not work 😞

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

Nemo1 — Tue, 13 Aug 2024 08:33:04 GMT

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.