Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create a horizontal table in qlik sense?

How to create a horizontal table in qlik sense like the picture show?

无标题.png

8 Replies
ogster1974
Partner - Master II
Partner - Master II

Pivot table?

ogster1974
Partner - Master II
Partner - Master II

Row =Year

Colum =Month

Measure =your % values

Not applicable
Author

Thank you,Let me try.

ogster1974
Partner - Master II
Partner - Master II

‌Let us know how you get on.

Not applicable
Author

Thank you,but Pivot table has this part which i don't like it,how to delete it?无标题.png

ogster1974
Partner - Master II
Partner - Master II

you cannot delete a core part of the chart its for filtering columns and rows and is inbuilt.  As you have only alittle room the responsive layout has made it a little cramped

Not applicable
Author

Is there a table can achieve this effect?

ogster1974
Partner - Master II
Partner - Master II

Yes you could use a simple table but you'd have to work your data a lot to mimic what is in effect a pivot table.

Something like

Dimension Year

12 measures (1 per month) using set analysis to filter on month.