https://community.qlik.com/t5/QlikView/Straight-Table/m-p/1531325#M598810 <P>Good day,</P><P>I am still fairly new to Qlikview.</P><P>I have a dataset as per the below:</P><TABLE><TBODY><TR><TD>Calendar Day</TD><TD>Date</TD><TD>Qty</TD></TR><TR><TD>FY19</TD><TD>Jul-18</TD><TD>3642</TD></TR><TR><TD>FY19</TD><TD>Aug-18</TD><TD>219</TD></TR><TR><TD>FY19</TD><TD>Sep-18</TD><TD>6033</TD></TR><TR><TD>FY19</TD><TD>Oct-18</TD><TD>1656</TD></TR><TR><TD>FY19</TD><TD>Nov-18</TD><TD>7436</TD></TR><TR><TD>FY18</TD><TD>Jul-18</TD><TD>2713</TD></TR><TR><TD>FY18</TD><TD>Aug-18</TD><TD>1210</TD></TR><TR><TD>FY18</TD><TD>Sep-18</TD><TD>2671</TD></TR><TR><TD>FY18</TD><TD>Oct-18</TD><TD>348</TD></TR><TR><TD>FY18</TD><TD>Nov-18</TD><TD>4975</TD></TR><TR><TD>FY17</TD><TD>Jul-18</TD><TD>3430</TD></TR><TR><TD>FY17</TD><TD>Aug-18</TD><TD>1797</TD></TR><TR><TD>FY17</TD><TD>Sep-18</TD><TD>2656</TD></TR><TR><TD>FY17</TD><TD>Oct-18</TD><TD>611</TD></TR><TR><TD>FY17</TD><TD>Nov-18</TD><TD>3241</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need for the data set to&nbsp; appear as per the below, each financial year on its own line.&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>July&nbsp;</TD><TD>Aug</TD><TD>Sep</TD><TD>Oct</TD><TD>Nov</TD></TR><TR><TD>FY17</TD><TD>3642</TD><TD>219</TD><TD>6033</TD><TD>1656</TD><TD>7436</TD></TR><TR><TD>FY18</TD><TD>2713</TD><TD>1210</TD><TD>2671</TD><TD>348</TD><TD>4975</TD></TR><TR><TD>FY19</TD><TD>3430</TD><TD>1797</TD><TD>2656</TD><TD>611</TD><TD>3241</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have created Date, Year, Month and Quarter fields in the edit script.</P><P>Please could someone assist me to a resolution.&nbsp;</P><P>Thanking you kindly.</P><P>Joanne</P> Thu, 17 Jan 2019 04:29:19 GMT joanneandrews 2019-01-17T04:29:19Z https://community.qlik.com/t5/QlikView/Straight-Table/m-p/1531325#M598810 <P>Good day,</P><P>I am still fairly new to Qlikview.</P><P>I have a dataset as per the below:</P><TABLE><TBODY><TR><TD>Calendar Day</TD><TD>Date</TD><TD>Qty</TD></TR><TR><TD>FY19</TD><TD>Jul-18</TD><TD>3642</TD></TR><TR><TD>FY19</TD><TD>Aug-18</TD><TD>219</TD></TR><TR><TD>FY19</TD><TD>Sep-18</TD><TD>6033</TD></TR><TR><TD>FY19</TD><TD>Oct-18</TD><TD>1656</TD></TR><TR><TD>FY19</TD><TD>Nov-18</TD><TD>7436</TD></TR><TR><TD>FY18</TD><TD>Jul-18</TD><TD>2713</TD></TR><TR><TD>FY18</TD><TD>Aug-18</TD><TD>1210</TD></TR><TR><TD>FY18</TD><TD>Sep-18</TD><TD>2671</TD></TR><TR><TD>FY18</TD><TD>Oct-18</TD><TD>348</TD></TR><TR><TD>FY18</TD><TD>Nov-18</TD><TD>4975</TD></TR><TR><TD>FY17</TD><TD>Jul-18</TD><TD>3430</TD></TR><TR><TD>FY17</TD><TD>Aug-18</TD><TD>1797</TD></TR><TR><TD>FY17</TD><TD>Sep-18</TD><TD>2656</TD></TR><TR><TD>FY17</TD><TD>Oct-18</TD><TD>611</TD></TR><TR><TD>FY17</TD><TD>Nov-18</TD><TD>3241</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need for the data set to&nbsp; appear as per the below, each financial year on its own line.&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>July&nbsp;</TD><TD>Aug</TD><TD>Sep</TD><TD>Oct</TD><TD>Nov</TD></TR><TR><TD>FY17</TD><TD>3642</TD><TD>219</TD><TD>6033</TD><TD>1656</TD><TD>7436</TD></TR><TR><TD>FY18</TD><TD>2713</TD><TD>1210</TD><TD>2671</TD><TD>348</TD><TD>4975</TD></TR><TR><TD>FY19</TD><TD>3430</TD><TD>1797</TD><TD>2656</TD><TD>611</TD><TD>3241</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have created Date, Year, Month and Quarter fields in the edit script.</P><P>Please could someone assist me to a resolution.&nbsp;</P><P>Thanking you kindly.</P><P>Joanne</P> Thu, 17 Jan 2019 04:29:19 GMT https://community.qlik.com/t5/QlikView/Straight-Table/m-p/1531325#M598810 joanneandrews 2019-01-17T04:29:19Z https://community.qlik.com/t5/QlikView/Straight-Table/m-p/1531335#M598811 <P>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.</P> Thu, 17 Jan 2019 05:32:12 GMT https://community.qlik.com/t5/QlikView/Straight-Table/m-p/1531335#M598811 jonathandienst 2019-01-17T05:32:12Z