Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Straight table with Month in column

Hi i need to put a table like this, with in column my month (field MESE_COMPETENZA)

and in my row my field AGENZIA

tha value is CONSUMO_SMC

How can i do that?

Thanks

danosoft_0-1597235610428.png

 

1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

try like that:

- create a diagram > pivot table

- add 2 dimensions AGENZIA & MESE_COMPETENZA

- add expression sum(CONSUMO_SMC)

- drag and drop the month dimension to the top

- i think you want to tick the checkbox  "Always Fully Expanded" on presentation tab

drag_pivot.png

 

 

View solution in original post

1 Reply
zhadrakas
Specialist II
Specialist II

try like that:

- create a diagram > pivot table

- add 2 dimensions AGENZIA & MESE_COMPETENZA

- add expression sum(CONSUMO_SMC)

- drag and drop the month dimension to the top

- i think you want to tick the checkbox  "Always Fully Expanded" on presentation tab

drag_pivot.png