topic Re: How to create this specific table in QlikView https://community.qlik.com/t5/QlikView/How-to-create-this-specific-table/m-p/1094127#M363565 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I thought in two solutions</P><P>1- You can create a dimension month-year and each row will be an expression</P><P>2- You can do a set analysis for each column with a period, e.g&nbsp; sum(&lt;month={}, year={}&gt;) and in the name of the column you edit as the month-year</P><P></P><P>Best Regards</P></BODY></HTML> Tue, 23 Feb 2016 18:09:22 GMT Anonymous 2016-02-23T18:09:22Z How to create this specific table https://community.qlik.com/t5/QlikView/How-to-create-this-specific-table/m-p/1094125#M363563 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P>How to create this specific format of table in qlik. It should contain data for full year&nbsp; and then YTD. In Excel it's easy to do, but in Qlik I can't handle it. </P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/115605_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Thanks in advance.</P></BODY></HTML> Tue, 23 Feb 2016 11:45:35 GMT https://community.qlik.com/t5/QlikView/How-to-create-this-specific-table/m-p/1094125#M363563 salezian 2016-02-23T11:45:35Z Re: How to create this specific table https://community.qlik.com/t5/QlikView/How-to-create-this-specific-table/m-p/1094126#M363564 <HTML><HEAD></HEAD><BODY><P>Are you looking to create this on the front end or backend? Can you possiblly share some data (in Excel file)?</P></BODY></HTML> Tue, 23 Feb 2016 17:56:12 GMT https://community.qlik.com/t5/QlikView/How-to-create-this-specific-table/m-p/1094126#M363564 sunny_talwar 2016-02-23T17:56:12Z Re: How to create this specific table https://community.qlik.com/t5/QlikView/How-to-create-this-specific-table/m-p/1094127#M363565 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I thought in two solutions</P><P>1- You can create a dimension month-year and each row will be an expression</P><P>2- You can do a set analysis for each column with a period, e.g&nbsp; sum(&lt;month={}, year={}&gt;) and in the name of the column you edit as the month-year</P><P></P><P>Best Regards</P></BODY></HTML> Tue, 23 Feb 2016 18:09:22 GMT https://community.qlik.com/t5/QlikView/How-to-create-this-specific-table/m-p/1094127#M363565 Anonymous 2016-02-23T18:09:22Z