Is there a way of showing different Months horizontally in the pivot table?

[nevilledhamsiri]

Hi,

I have a field which is a  dimension which carries the different Months such as JAN,FEB,MAR etc. How I could show all these Months  horizontally in the pivot table?

Load

Month

--

Neville

[eduardo_dimperio]

Hi Neville,

Use Crosstable:

https://help.qlik.com/pt-BR/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptPrefixes/crosstable.htm

[Peter_Cammaert]

Create a Pivot table with all required dimensions and expressions.

Now click and drag the Month column to the top of the pivot table. The blue positioning arrow will turn 90° coiunter-clockwise. Release the mouse button.

All expressions (if you have multiple) will be repeated for every Month value available.

[buzzy996 · Accepted solution]

just add ur month attribute as dimension column on pivot table and frm front end(frm pivot table) drag that column by pressing shift+ctrl (u will see blue lines) drop tht column as a header for ur whole table.