topic Re: Straight Tables with Labels and Calculated Cells in QlikView https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703766#M253839 <HTML><HEAD></HEAD><BODY><P>Use a pivot table without dimensions and 3 expression having your formulas ...</P><P></P><P>let me know</P></BODY></HTML> Mon, 27 Oct 2014 13:38:18 GMT alexandros17 2014-10-27T13:38:18Z Straight Tables with Labels and Calculated Cells https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703765#M253838 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How can I make a straight table (or an equivalent) that will be as such where one column is labels, and the other is calculated (without the parentheses):</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TD style="padding: 2px;">Number of customers</TD><TD style="padding: 2px;">25 (actual code is "=count(customers)")</TD></TR><TR><TD style="padding: 2px;">Sum of Sales</TD><TD style="padding: 2px;">$37,569 (actual code is "=sum(sales)")</TD></TR><TR><TD>Average of sales</TD><TD>$56 (actual code is "=avg(sales)")</TD></TR></TBODY></TABLE><P>Thanks!</P></BODY></HTML> Mon, 27 Oct 2014 13:34:54 GMT https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703765#M253838 2014-10-27T13:34:54Z Re: Straight Tables with Labels and Calculated Cells https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703766#M253839 <HTML><HEAD></HEAD><BODY><P>Use a pivot table without dimensions and 3 expression having your formulas ...</P><P></P><P>let me know</P></BODY></HTML> Mon, 27 Oct 2014 13:38:18 GMT https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703766#M253839 alexandros17 2014-10-27T13:38:18Z Re: Straight Tables with Labels and Calculated Cells https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703767#M253840 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Take a look on the attached file.</P><P></P><P>Regards,</P><P>Gabriel</P></BODY></HTML> Mon, 27 Oct 2014 13:44:06 GMT https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703767#M253840 Anonymous 2014-10-27T13:44:06Z Re: Straight Tables with Labels and Calculated Cells https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703768#M253841 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Just create a normal straight table with no dimensions and multiple expressions. Then in Properties | Presentation, check the Horizontal check box. You will want to turn off the totals for the expressions as well.</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Mon, 27 Oct 2014 13:47:21 GMT https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703768#M253841 jonathandienst 2014-10-27T13:47:21Z Re: Straight Tables with Labels and Calculated Cells https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703769#M253842 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P>As always, it's amazing how fast this community works <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 27 Oct 2014 13:59:09 GMT https://community.qlik.com/t5/QlikView/Straight-Tables-with-Labels-and-Calculated-Cells/m-p/703769#M253842 2014-10-27T13:59:09Z