Straight Table

[joanneandrews]

Good day,

I am still fairly new to Qlikview.

I have a dataset as per the below:

Calendar Day	Date	Qty
FY19	Jul-18	3642
FY19	Aug-18	219
FY19	Sep-18	6033
FY19	Oct-18	1656
FY19	Nov-18	7436
FY18	Jul-18	2713
FY18	Aug-18	1210
FY18	Sep-18	2671
FY18	Oct-18	348
FY18	Nov-18	4975
FY17	Jul-18	3430
FY17	Aug-18	1797
FY17	Sep-18	2656
FY17	Oct-18	611
FY17	Nov-18	3241

I need for the data set to  appear as per the below, each financial year on its own line. 

	July	Aug	Sep	Oct	Nov
FY17	3642	219	6033	1656	7436
FY18	2713	1210	2671	348	4975
FY19	3430	1797	2656	611	3241

I have created Date, Year, Month and Quarter fields in the edit script.

Please could someone assist me to a resolution. 

Thanking you kindly.

Joanne

[jonathandienst · Accepted solution]

This is not a straight table, its a pivot. Create a pivot table and add the appropriate fields for the row (FY) and column (Month) dimensions. Then use Sum(Qty) as the expression. If you are using Qlikview, drag the month dimension to the top of the table.