Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have an Excel table with several months as colums:
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?
I created an simple excel like this
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.
See attached qvf and read up on the CROSSTABLE functionality in Qlik Sense