topic Re: How to group similar values in a Straight Table in QlikView https://community.qlik.com/t5/QlikView/How-to-group-similar-values-in-a-Straight-Table/m-p/944841#M325476 <HTML><HEAD></HEAD><BODY><P>Awesome Robert <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 17 Dec 2015 10:27:47 GMT sunny_talwar 2015-12-17T10:27:47Z How to group similar values in a Straight Table https://community.qlik.com/t5/QlikView/How-to-group-similar-values-in-a-Straight-Table/m-p/944839#M325474 <HTML><HEAD></HEAD><BODY><P>So, instead of showing table A below, I want to format it like table B.</P><P></P><P>Thanks</P><P></P><P><STRONG>Table A:</STRONG><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="244"><TBODY><TR><TD height="17" style="border: 0px black; border-image: none;" width="94"><SPAN style="color: #000000;">Project ID</SPAN></TD><TD style="border: 0px black; border-image: none;" width="150"><SPAN style="color: #000000;">Submitted Item ID</SPAN></TD></TR><TR><TD align="right" height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">123</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Apple</SPAN></TD></TR><TR><TD align="right" height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">123</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Banana</SPAN></TD></TR><TR><TD align="right" height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">123</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Orange</SPAN></TD></TR><TR><TD align="right" height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">123</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Pear</SPAN></TD></TR><TR><TD align="right" height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">456</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Banana</SPAN></TD></TR><TR><TD align="right" height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">456</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Orange</SPAN></TD></TR><TR><TD align="right" height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">456</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Pear</SPAN></TD></TR><TR><TD align="right" height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">456</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Watermelon</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P><STRONG>Table B:</STRONG><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="244"><TBODY><TR><TD height="17" style="border: 0px black; border-image: none;" width="94"><SPAN style="color: #000000;">Project ID</SPAN></TD><TD style="border: 0px black; border-image: none;" width="150"><SPAN style="color: #000000;">Submitted Item ID</SPAN></TD></TR><TR><TD height="68" rowspan="4" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">123</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Apple</SPAN></TD></TR><TR><TD height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Banana</SPAN></TD></TR><TR><TD height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Orange</SPAN></TD></TR><TR><TD height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Pear</SPAN></TD></TR><TR><TD height="68" rowspan="4" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">456</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Banana</SPAN></TD></TR><TR><TD height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Orange</SPAN></TD></TR><TR><TD height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Pear</SPAN></TD></TR><TR><TD height="17" style="border: 0px black; border-image: none;"><SPAN style="color: #000000;">Watermelon</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 16 Dec 2015 22:02:00 GMT https://community.qlik.com/t5/QlikView/How-to-group-similar-values-in-a-Straight-Table/m-p/944839#M325474 Anonymous 2015-12-16T22:02:00Z Re: How to group similar values in a Straight Table https://community.qlik.com/t5/QlikView/How-to-group-similar-values-in-a-Straight-Table/m-p/944840#M325475 <HTML><HEAD></HEAD><BODY><P>Create extra expression</P><P>Enter 1</P><P><IMG __jive_id="109231" alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/109231_Capture.PNG" style="height: auto;" /></P><P>Hide the Expression in presentation tab</P><P>In Dimensions under Text use</P><P>=if(RowNo()=1,Black(),White())</P><P><IMG __jive_id="109235" alt="Capture.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/109235_Capture.PNG" style="height: auto;" /></P><P></P><P></P><P><IMG __jive_id="109230" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109230_Capture.PNG" style="height: auto;" /></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(23 articles)</A></P></BODY></HTML> Wed, 16 Dec 2015 22:19:49 GMT https://community.qlik.com/t5/QlikView/How-to-group-similar-values-in-a-Straight-Table/m-p/944840#M325475 robert_mika 2015-12-16T22:19:49Z Re: How to group similar values in a Straight Table https://community.qlik.com/t5/QlikView/How-to-group-similar-values-in-a-Straight-Table/m-p/944841#M325476 <HTML><HEAD></HEAD><BODY><P>Awesome Robert <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 17 Dec 2015 10:27:47 GMT https://community.qlik.com/t5/QlikView/How-to-group-similar-values-in-a-Straight-Table/m-p/944841#M325476 sunny_talwar 2015-12-17T10:27:47Z Re: How to group similar values in a Straight Table https://community.qlik.com/t5/QlikView/How-to-group-similar-values-in-a-Straight-Table/m-p/944842#M325477 <HTML><HEAD></HEAD><BODY><P>Smart Solution:)</P></BODY></HTML> Thu, 17 Dec 2015 14:13:31 GMT https://community.qlik.com/t5/QlikView/How-to-group-similar-values-in-a-Straight-Table/m-p/944842#M325477 Anonymous 2015-12-17T14:13:31Z