How can I turn a table from horizontal to vertical

[rittermd]

I have data by month.

I want to see the months across the top (columns) and the rest of the data in rows.  By default I am getting the opposite and I don't see how to change that in Qlik Sense.

[ahmar811]

can you share your the sample .qvf ?

[#3]

Make Use Of Pivot Table

And put in your Dimension as Rows and Measures As Column.

You Might get Desired Output

Regards,

[saniyask]

Hi,

Its not possible in qlik sense using straight table, whereas you can do it via pivot table..

You can use a pivot table and move the rows to columns and vice versa

Regards,

Saniya

[settu_periasamy]

Not sure the below option available in QlikSense. In Qlikview Straight Table -> Horizontal option in Presentation tab..

[petter]

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:

[petter]

Notice that this is a Qlik Sense forum not a QlikView forum....

[rittermd]

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.

[petter]

The filters (...) thing also works with XLSX-files

[#10]

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.

[rittermd]

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. 

[Sheet1]:

LOAD [Period] AS [HRPeriod],

                [Open],

                [AvgTime],

                [Hires],

                [AvgCost],

                [Contract_Labor],

                [PT],

                [OT],

                [ST],

                [PTA],

                [OTA],

                [HRSORT],

                [Directors],

                [Over 60],

                [Over 6 Mos],

                [Avg Days],

                [PT$],

                [OT$],

                [ST$],

                [PTA$],

                [OTA$]

FROM [lib://Dashboard Data/HRMETRICS.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(Rotate(right)

);