Good morning a query as I can have two bar graphs 1st graph showing the cumulative current year to the selected month and the 2nd graph to show only selected month information example:
I have selected 2015 and May I want the first chart shows the information accumulated from January to May 2015
and the second graph shows the information only in May.
I have 1 dimension and a bunch of measures.
By default Qlik Sense is putting the dimension on the left and the measures across the top.
Because I have so many measures I want them to go down the left and have the Dimension be the columns. I only have 3 values for the Dimension.
I don't see how to make this happen in QS?
I don't want or need a Pivot Table.
When you say that you have many measures - do you mean many different measures or one measure with many values? Could you give us more specifics about what kind of dimension you have and the many measures you have and how you would like your table to look like?
Sure there are ways of rotating your data also in script without turning to a pivot table...
I used a workaround for this.
According to my understanding, your dimensions are in the form of rows. To convert them into columns, you will have to use Generic load. Refer this link for Generic load.
For the measures part, which are in columns, use Crosstable load to convert them into rows. Refer this link for Crosstable load.
You can easily do this in Qlik Sense with only one line of extra code in your load statement:
filters(Rotate(right)) 10th line in the load script below:
Rotate Table in Script.qvf 176.0 K
To do this do I need to use a CSV instead of an XLSX format?
Also, where is the default location that Qlik Sense desktop is looking for data file?
I tried to convert my xlsx file to csv and left in the same folder on my desktop. But the code you used says invalid path.
I tried (lib://Dashboard Data/HRMETRICS.csv). This works with the xlsx file.
This is the code I am trying to get to work. When I load this I get an error that [Open} can not be found. I am not quite sure what I am doing wrong here. HRPERIOD is the Dimension that I want on the top. I want all of the others displayed on the left.
LOAD [Period] AS [HRPeriod],
[Over 6 Mos],
FROM [lib://Dashboard Data/HRMETRICS.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(Rotate(right)