topic Re: Group values in a dimension column in QlikView https://community.qlik.com/t5/QlikView/Group-values-in-a-dimension-column/m-p/909003#M315657 <HTML><HEAD></HEAD><BODY><P>Any other guidance Qlik Gurus?</P></BODY></HTML> Fri, 24 Jul 2015 05:09:05 GMT 2015-07-24T05:09:05Z Group values in a dimension column https://community.qlik.com/t5/QlikView/Group-values-in-a-dimension-column/m-p/909000#M315654 <HTML><HEAD></HEAD><BODY><P>Hello QGurus&nbsp; – In the attached qvw, we can see the raw data and equivalent representation in pivot table. However, my customer is expecting output in one of the following format. Any guidance on how we might achieve it without having to modifying the raw data? Many thanks!</P><P></P><P><STRONG>Expected Output</STRONG></P><P><STRONG><IMG __jive_id="93558" alt="Expected Output.JPG" class="jive-image image-2" height="306" src="/legacyfs/online/93558_Expected Output.JPG" style="height: 306px; width: 350.88px;" width="351" /><BR /></STRONG></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG><BR />Raw Data</STRONG></SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="635"><TBODY><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"><STRONG>LastName</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"><STRONG>FirstName</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"><STRONG>Parents</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-left: none; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="255"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"><STRONG>Child</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Morgan</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Debra</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Doris</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="255"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Nicholas</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Morgan</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Debra</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Harry</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="255"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Nicholas</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Morgan</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dexter</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Harry</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="255"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Astor</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Morgan</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dexter</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Harry</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="255"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Cody</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Morgan</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dexter</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Harry</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="255"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Harrison</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Morgan</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dexter</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Laura</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="255"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Astor</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Morgan</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dexter</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Laura</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="255"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Cody</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Morgan</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dexter</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="127"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Laura</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="255"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Harrison</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P><STRONG>Pivot Table We're Looking to Modify</STRONG></P><P><IMG __jive_id="93557" alt="Pivot Issue.JPG" class="jive-image image-1" src="/legacyfs/online/93557_Pivot Issue.JPG" style="height: 171px; width: 620px;" /></P></BODY></HTML> Tue, 21 Jul 2015 20:13:30 GMT https://community.qlik.com/t5/QlikView/Group-values-in-a-dimension-column/m-p/909000#M315654 2015-07-21T20:13:30Z Re: Group values in a dimension column https://community.qlik.com/t5/QlikView/Group-values-in-a-dimension-column/m-p/909001#M315655 <HTML><HEAD></HEAD><BODY><P>I dont believe this is feasible </P></BODY></HTML> Tue, 21 Jul 2015 23:32:40 GMT https://community.qlik.com/t5/QlikView/Group-values-in-a-dimension-column/m-p/909001#M315655 ramoncova06 2015-07-21T23:32:40Z Re: Group values in a dimension column https://community.qlik.com/t5/QlikView/Group-values-in-a-dimension-column/m-p/909002#M315656 <HTML><HEAD></HEAD><BODY><P>Thank you for your input @Ramon!</P></BODY></HTML> Fri, 24 Jul 2015 05:08:13 GMT https://community.qlik.com/t5/QlikView/Group-values-in-a-dimension-column/m-p/909002#M315656 2015-07-24T05:08:13Z Re: Group values in a dimension column https://community.qlik.com/t5/QlikView/Group-values-in-a-dimension-column/m-p/909003#M315657 <HTML><HEAD></HEAD><BODY><P>Any other guidance Qlik Gurus?</P></BODY></HTML> Fri, 24 Jul 2015 05:09:05 GMT https://community.qlik.com/t5/QlikView/Group-values-in-a-dimension-column/m-p/909003#M315657 2015-07-24T05:09:05Z