Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Qlikview PivotTable

     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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Qlikview PivotTable

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.


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Qlikview PivotTable

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.


talk is cheap, supply exceeds demand
agomes1971
Valued Contributor II

Re: Qlikview PivotTable

Hi,

see this thread

Pivot Table

HTH

André Gomes