topic Re: I Need All Dimension Values in Straight Table in QlikView https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364522#M135637 <HTML><HEAD></HEAD><BODY><P>You haven't unchecked the "Suppress Zero Values" in the presentation tab like I said to do.</P></BODY></HTML> Wed, 23 May 2012 07:42:29 GMT Jason_Michaelides 2012-05-23T07:42:29Z I Need All Dimension Values in Straight Table https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364517#M135632 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>please consider the following tables :</P><P></P><P>T1</P><P>___________</P><P><SPAN style="color: #0000ff;">F1&nbsp;&nbsp; F2&nbsp;&nbsp;&nbsp; F3</SPAN></P><P><SPAN style="color: #ff0000;">1&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp; A10</SPAN></P><P><SPAN style="color: #ff0000;">2&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp; A20</SPAN></P><P><SPAN style="color: #ff0000;">3&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp; B10</SPAN></P><P><SPAN style="color: #ff0000;">4&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp; B20</SPAN></P><P><SPAN style="color: #ff0000;">5&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp; B30</SPAN></P><P></P><P>T2</P><P>_______</P><P><SPAN style="color: #0000ff;">F1&nbsp;&nbsp; F4</SPAN></P><P><SPAN style="color: #ff0000;">1&nbsp;&nbsp;&nbsp;&nbsp; 5</SPAN></P><P><SPAN style="color: #ff0000;">1&nbsp;&nbsp;&nbsp;&nbsp; 10</SPAN></P><P><SPAN style="color: #ff0000;">3&nbsp;&nbsp;&nbsp;&nbsp; 12</SPAN></P><P><SPAN style="color: #ff0000;">3&nbsp;&nbsp;&nbsp;&nbsp; 17</SPAN></P><P><SPAN style="color: #ff0000;">5&nbsp;&nbsp;&nbsp;&nbsp; 20</SPAN></P><P><SPAN style="color: #ff0000;">5&nbsp;&nbsp;&nbsp;&nbsp; 7</SPAN></P><P><SPAN style="color: #ff0000;">5&nbsp;&nbsp;&nbsp;&nbsp; 4</SPAN></P><P></P><P>then i have a Straight Table Chart with F2 &amp; F3 as dimensions and sum(F4) as expression. the result is :</P><P></P><P><SPAN style="color: #008000;">A&nbsp;&nbsp;&nbsp;&nbsp; A10&nbsp;&nbsp;&nbsp;&nbsp; 15</SPAN></P><P><SPAN style="color: #008000;">B&nbsp;&nbsp;&nbsp;&nbsp; B10&nbsp;&nbsp;&nbsp;&nbsp; 29</SPAN></P><P><SPAN style="color: #008000;">B&nbsp;&nbsp;&nbsp;&nbsp; B30&nbsp;&nbsp;&nbsp;&nbsp; 31</SPAN></P><P></P><P>and it is what we excpect from a straight table. but i need the result with all F2 &amp; F3 values. My result sould look like:</P><P></P><P><SPAN style="color: #008000;">A&nbsp;&nbsp;&nbsp;&nbsp; A10&nbsp;&nbsp;&nbsp;&nbsp; 15</SPAN></P><P><SPAN style="color: #ff6600;">A&nbsp;&nbsp;&nbsp;&nbsp; A20&nbsp;&nbsp;&nbsp;&nbsp; 0</SPAN></P><P><SPAN style="color: #008000;">B&nbsp;&nbsp;&nbsp;&nbsp; B10&nbsp;&nbsp;&nbsp;&nbsp; 29</SPAN></P><P><SPAN style="color: #ff6600;">B&nbsp;&nbsp;&nbsp;&nbsp; B20&nbsp;&nbsp;&nbsp;&nbsp; 0</SPAN></P><P><SPAN style="color: #008000;">B&nbsp;&nbsp;&nbsp;&nbsp; B30&nbsp;&nbsp;&nbsp;&nbsp; 31</SPAN></P><P></P><P></P><P><SPAN style="color: #000000;">the sample qvw with above data and chart is attached. Thank you forward for any help or idea.</SPAN></P><P></P><P><SPAN style="color: #000000;">Best Regards</SPAN></P><P><SPAN style="color: #000000;">Peyman<BR /></SPAN></P></BODY></HTML> Wed, 23 May 2012 06:50:39 GMT https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364517#M135632 azimabadi 2012-05-23T06:50:39Z I Need All Dimension Values in Straight Table https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364518#M135633 <HTML><HEAD></HEAD><BODY><P>Can't open the app at the moment but try unchecking "Supress zero value" I'm the presentation tab. You may also need to check Show All Values on the dimension tab. </P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Wed, 23 May 2012 06:53:54 GMT https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364518#M135633 Jason_Michaelides 2012-05-23T06:53:54Z I Need All Dimension Values in Straight Table https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364519#M135634 <HTML><HEAD></HEAD><BODY><P>Hi Jason, Thank you for answer.</P><P>I have tried all options, but i can't get the answer i need <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" />!</P></BODY></HTML> Wed, 23 May 2012 07:08:11 GMT https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364519#M135634 azimabadi 2012-05-23T07:08:11Z Re: I Need All Dimension Values in Straight Table https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364520#M135635 <HTML><HEAD></HEAD><BODY><P>Works for me.&nbsp; See attached.</P></BODY></HTML> Wed, 23 May 2012 07:27:45 GMT https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364520#M135635 Jason_Michaelides 2012-05-23T07:27:45Z Re: I Need All Dimension Values in Straight Table https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364521#M135636 <HTML><HEAD></HEAD><BODY><P>You are right! But i did the same and get another result. can you please check my qvw againe and see if i have made something wrong?</P></BODY></HTML> Wed, 23 May 2012 07:34:45 GMT https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364521#M135636 azimabadi 2012-05-23T07:34:45Z Re: I Need All Dimension Values in Straight Table https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364522#M135637 <HTML><HEAD></HEAD><BODY><P>You haven't unchecked the "Suppress Zero Values" in the presentation tab like I said to do.</P></BODY></HTML> Wed, 23 May 2012 07:42:29 GMT https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364522#M135637 Jason_Michaelides 2012-05-23T07:42:29Z Re: I Need All Dimension Values in Straight Table https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364523#M135638 <HTML><HEAD></HEAD><BODY><P>Thank you so much Jason!</P><P>All the Best</P><P>Peyman</P></BODY></HTML> Wed, 23 May 2012 07:45:46 GMT https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364523#M135638 azimabadi 2012-05-23T07:45:46Z Re: I Need All Dimension Values in Straight Table https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364524#M135639 <HTML><HEAD></HEAD><BODY><P>now there is another problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" />!</P><P>please consider the following qvw, is there anyway that i can show the result in bottom table as in above?</P></BODY></HTML> Wed, 23 May 2012 08:40:42 GMT https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364524#M135639 azimabadi 2012-05-23T08:40:42Z Re: I Need All Dimension Values in Straight Table https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364525#M135640 <HTML><HEAD></HEAD><BODY><P>i post the question again as a new discussion, becuse this one is marked as answerd.</P></BODY></HTML> Wed, 23 May 2012 08:49:03 GMT https://community.qlik.com/t5/QlikView/I-Need-All-Dimension-Values-in-Straight-Table/m-p/364525#M135640 azimabadi 2012-05-23T08:49:03Z