topic Re: Straight table Help in QlikView https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904876#M469642 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Have you checked with Total, Count(distinct BrandID)/count(Total Distinct BrandID). </SPAN></P></BODY></HTML> Fri, 26 Jun 2015 04:38:26 GMT 2015-06-26T04:38:26Z Straight table Help https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904875#M469641 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am struck up in a small expression. </P><P>I am using s straight table where i have a calculated dimension </P><P><STRONG>FirstSortedValue(Brand,-[SaleDate] &amp; BrandID &amp; [RowNo()]))</STRONG> as primary dimension&nbsp; and Year as secondary dimension.</P><P>Now i need to calculate average as </P><P><STRONG>Brand&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; Count( distinct BrandID)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Avg</STRONG></P><P><STRONG>Levis&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&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; 2/2+3+7</STRONG></P><P><STRONG style="font-size: 13.3333330154419px;">Lee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&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; 3<SPAN style="font-size: 13.3333330154419px;">/2+3+7</SPAN></STRONG></P><P><SPAN style="font-size: 13.3333330154419px;"><STRONG>Mufti&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&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; 7</STRONG><SPAN style="font-size: 13.3333330154419px;"><STRONG>/2+3+7</STRONG></SPAN><BR /></SPAN></P></BODY></HTML> Fri, 26 Jun 2015 04:15:08 GMT https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904875#M469641 sujeetsingh 2015-06-26T04:15:08Z Re: Straight table Help https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904876#M469642 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Have you checked with Total, Count(distinct BrandID)/count(Total Distinct BrandID). </SPAN></P></BODY></HTML> Fri, 26 Jun 2015 04:38:26 GMT https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904876#M469642 2015-06-26T04:38:26Z Re: Straight table Help https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904877#M469643 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Write Expression for average in Expressions tab.sum(Values)/Count(Values)</P><P></P><P>Thanks</P></BODY></HTML> Fri, 26 Jun 2015 04:41:54 GMT https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904877#M469643 hariprasadqv 2015-06-26T04:41:54Z Re: Straight table Help https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904878#M469644 <HTML><HEAD></HEAD><BODY><P>I want the total at each row </P></BODY></HTML> Fri, 26 Jun 2015 04:45:41 GMT https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904878#M469644 sujeetsingh 2015-06-26T04:45:41Z Re: Straight table Help https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904879#M469645 <HTML><HEAD></HEAD><BODY><P>Achieved it with Range sum and rank function.</P></BODY></HTML> Fri, 26 Jun 2015 07:57:26 GMT https://community.qlik.com/t5/QlikView/Straight-table-Help/m-p/904879#M469645 sujeetsingh 2015-06-26T07:57:26Z