topic Re: Build table in QlikView https://community.qlik.com/t5/QlikView/Build-table/m-p/399788#M566795 <HTML><HEAD></HEAD><BODY><P>Are Store 1, Store 2 (and presumably Store 3) values of a dimension?</P><P></P><P>Then just build a standard straight table with this dimension and your 5 expressions (for calculation of 'Total of items sold' etc), and use the 'Horizontal' option (checkbox) in presentation tab.</P></BODY></HTML> Mon, 03 Dec 2012 12:31:32 GMT swuehl 2012-12-03T12:31:32Z Build table https://community.qlik.com/t5/QlikView/Build-table/m-p/399787#M566794 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>How can I build a custom table?</P><P></P><P>Here is an example of what I need: I need to construct a table with 5 rows and 3 column. The first column are only strings like "Total" or "Total Sales". In the other column is supposed to be some calculations (expressions) for each row.</P><P></P><P>Example:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Store 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Store 2</P><P>Total of items sold:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 465 </P><P>Total of money earned:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 465</P><P>...</P><P></P><P>You have to consider that these values are calculated by an expression.</P><P></P><P>Thanks in advance.</P><P></P><P>Best regards,</P><P>TMF</P></BODY></HTML> Mon, 03 Dec 2012 11:40:48 GMT https://community.qlik.com/t5/QlikView/Build-table/m-p/399787#M566794 2012-12-03T11:40:48Z Re: Build table https://community.qlik.com/t5/QlikView/Build-table/m-p/399788#M566795 <HTML><HEAD></HEAD><BODY><P>Are Store 1, Store 2 (and presumably Store 3) values of a dimension?</P><P></P><P>Then just build a standard straight table with this dimension and your 5 expressions (for calculation of 'Total of items sold' etc), and use the 'Horizontal' option (checkbox) in presentation tab.</P></BODY></HTML> Mon, 03 Dec 2012 12:31:32 GMT https://community.qlik.com/t5/QlikView/Build-table/m-p/399788#M566795 swuehl 2012-12-03T12:31:32Z