topic Assigning grouptext to groupvalue in QlikView https://community.qlik.com/t5/QlikView/Assigning-grouptext-to-groupvalue/m-p/312733#M706515 <HTML><HEAD></HEAD><BODY><P>Hello QVer,<BR />I can't find the right searchword which can solve this:<BR />I have TABLE1:<BR />G_FIRST&nbsp; | G_LAST | G_GROUP&nbsp; | G_GROUPTEXT&nbsp; |<BR />A00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A00-A04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A00A04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A15-A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B20-B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B25-B28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B25B28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>The other TABLE2 has all dedicated (from first to last) groupvalues in field (F1).<BR />A new field (F_GROUPTEXT) in this TABLE2 should assign G_GROUPTEXT to each value corresponding to a group as defined in TABLE1:</P><P>F1&nbsp;&nbsp; | F_Grouptext |<BR />A00 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A01 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A02 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A03 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A04 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A15 | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A16 | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A17 | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A18 | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B20 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B21 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B22 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B23 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B24 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />and so on.</P><P>Can somebody help me to solve this problem without doing it handmade. Thanks.<BR />greetings dj_skbs</P></BODY></HTML> Fri, 27 Jan 2012 10:53:18 GMT 2012-01-27T10:53:18Z Assigning grouptext to groupvalue https://community.qlik.com/t5/QlikView/Assigning-grouptext-to-groupvalue/m-p/312733#M706515 <HTML><HEAD></HEAD><BODY><P>Hello QVer,<BR />I can't find the right searchword which can solve this:<BR />I have TABLE1:<BR />G_FIRST&nbsp; | G_LAST | G_GROUP&nbsp; | G_GROUPTEXT&nbsp; |<BR />A00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A00-A04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A00A04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A15-A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B20-B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B25-B28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | B25B28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>The other TABLE2 has all dedicated (from first to last) groupvalues in field (F1).<BR />A new field (F_GROUPTEXT) in this TABLE2 should assign G_GROUPTEXT to each value corresponding to a group as defined in TABLE1:</P><P>F1&nbsp;&nbsp; | F_Grouptext |<BR />A00 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A01 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A02 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A03 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A04 | A00A05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A15 | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A16 | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A17 | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />A18 | A15A18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B20 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B21 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B22 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B23 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />B24 | B20B24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR />and so on.</P><P>Can somebody help me to solve this problem without doing it handmade. Thanks.<BR />greetings dj_skbs</P></BODY></HTML> Fri, 27 Jan 2012 10:53:18 GMT https://community.qlik.com/t5/QlikView/Assigning-grouptext-to-groupvalue/m-p/312733#M706515 2012-01-27T10:53:18Z