topic Re: Qlikview PivotTable in QlikView

Qlikview PivotTable

Wed, 04 Feb 2015 17:29:59 GMT

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.

Re: Qlikview PivotTable

Gysbert_Wassenaar — Wed, 04 Feb 2015 17:35:48 GMT

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.

Re: Qlikview PivotTable

agomes1971 — Wed, 04 Feb 2015 18:01:50 GMT

Hi,

see this thread

Pivot Table

HTH

André Gomes