Hi Michael, you can drag and drop excel in QV, this will open the File Assistant
Press Next 2 times and press the 'Cross table...' button
Set a name for the attribute field and another for the data:
From the you can create a bar chart with the attribute field (Month in my case) and an expression like:
Sum(DataField) (Value in my case)
In the 'Sort' tab you can check load order for month:
this way you can get this graph:
Again I didn't saw this was a Sense question, sorry.
It can work but I think the assistant can't help you with crosstable, you can avoid the assistant and edit the script directly, you can use:
(biff, embedded labels, table is Hoja1$);
Hope this helps
I have been able to get the information to display in Qlik Desktop using the formula above.
I have also added a table to show all the projects and all the months, to do this I had to add the load command again without the cross table reference.
However if I select a month using the chart produced above using the crosstable values, the table below does not show the project with values in that month (if that makes since).