Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
vivianrc
Contributor
Contributor

Using several colums as a dimension

Hi guys,

I have an Excel table with several months as colums:

table.PNG

And I would like to display it on Qlik Sense as a graph, with the months as the x-axis, and the sum of each colum as the value. How can I do that? 

 

 

1 Reply
Vegar
MVP
MVP

I created an simple excel like this

image.png

Used script like this:

CrossTable(Period, Value,1)
LOAD
   *
FROM 
   [lib://ExcelPath/vivianrc.xlsx]
  (ooxml, embedded labels, table is Sheet1);

That allows me to create a bar chart like this.

image.png

See attached qvf and read up on the CROSSTABLE functionality in Qlik Sense