Qlikview PivotTable

[#1]

     Hi,

I have data with the Days, Players, CurrentPoints(CP), PointsOfprevious (PP)

I want creat a table with 2 dimension where one is on ROW (day) and the Others is on Columns (Player) and my expression will be CP and PP. It should look like this:

                    Players

                    PLAYER A          PLAYER B          PLAYER C

Day              CP     PP             CP     PP              CP     PP                     

1/2/2000      XX     XX

2/2/2000       ..     ..

3/2/2000

XX will be the different values. How can I setup this in Qlikview? I dont know a way to put one dimension in columns.

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

You can drag the header of the dimension column to the right just above the expression headers. You should see a horizontal blue arrowed line appear. When it does release the dimension header and the dimension values will be displayed as columns.

[agomes1971]

Hi,

see this thread

Pivot Table

HTH

André Gomes