topic Re: Logic required in QlikView https://community.qlik.com/t5/QlikView/Logic-required/m-p/1397373#M802809 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>what is the rule to map the codes and the users ?</P></BODY></HTML> Wed, 15 Nov 2017 16:51:30 GMT YoussefBelloum 2017-11-15T16:51:30Z Logic required https://community.qlik.com/t5/QlikView/Logic-required/m-p/1397372#M802808 <HTML><HEAD></HEAD><BODY><P>HI All , </P><P></P><P>I have been trying on below data to get required output since long time.</P><P></P><P>I have data like below :</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="64"><TBODY><TR><TD height="20" width="64">Field</TD></TR><TR><TD height="20">User : Kalyan</TD></TR><TR><TD height="20">Loc:</TD></TR><TR><TD height="20">City</TD></TR><TR><TD height="20">Dest</TD></TR><TR><TD height="20">Code</TD></TR><TR><TD align="right" height="20">1001</TD></TR><TR><TD align="right" height="20">1002</TD></TR><TR><TD align="right" height="20">1003</TD></TR><TR><TD align="right" height="20">1004</TD></TR><TR><TD align="right" height="20">1005</TD></TR><TR><TD align="right" height="20">1006</TD></TR><TR><TD align="right" height="20">1007</TD></TR><TR><TD height="20">User : Ravi</TD></TR><TR><TD height="20">Loc:</TD></TR><TR><TD height="20">City</TD></TR><TR><TD height="20">Dest</TD></TR><TR><TD height="20">Code</TD></TR><TR><TD align="right" height="20">2001</TD></TR><TR><TD align="right" height="20">1007</TD></TR><TR><TD align="right" height="20">1004</TD></TR><TR><TD height="20">User : Shiva</TD></TR><TR><TD height="20">Loc:</TD></TR><TR><TD height="20">City</TD></TR><TR><TD height="20">Dest</TD></TR><TR><TD height="20">Country</TD></TR><TR><TD height="20">Code</TD></TR><TR><TD align="right" height="20">2008</TD></TR><TR><TD align="right" height="20">2010</TD></TR><TR><TD align="right" height="20">2003</TD></TR><TR><TD align="right" height="20">3289</TD></TR><TR><TD align="right" height="20">3892</TD></TR><TR><TD align="right" height="20"><P>8221</P><P></P></TD></TR></TBODY></TABLE><P>I want output like below :</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD height="20" width="64">User </TD><TD width="64">Code</TD></TR><TR><TD height="20">Kalyan</TD><TD align="right">1001</TD></TR><TR><TD height="20">Kalyan</TD><TD align="right">1002</TD></TR><TR><TD height="20">Kalyan</TD><TD align="right">1003</TD></TR><TR><TD height="20">Kalyan</TD><TD align="right">1004</TD></TR><TR><TD height="20">Kalyan</TD><TD align="right">1005</TD></TR><TR><TD height="20">Kalyan</TD><TD align="right">1006</TD></TR><TR><TD height="20">Kalyan</TD><TD align="right">1007</TD></TR><TR><TD height="20">Ravi</TD><TD align="right">2001</TD></TR><TR><TD height="20">Ravi</TD><TD align="right">1007</TD></TR><TR><TD height="20">Ravi</TD><TD align="right">1004</TD></TR><TR><TD height="20">Shiva</TD><TD align="right">2008</TD></TR><TR><TD height="20">Shiva</TD><TD align="right">2010</TD></TR><TR><TD height="20">Shiva</TD><TD align="right">2003</TD></TR><TR><TD height="20">Shiva</TD><TD align="right">3289</TD></TR><TR><TD height="20">Shiva</TD><TD align="right">3892</TD></TR><TR><TD height="20">Shiva</TD><TD align="right">8221</TD></TR></TBODY></TABLE><P></P><P></P><P>Can anyone tell me how to achieve this in back end?</P><P></P><P></P><P>!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Logic-required/m-p/1397372#M802808 subbareddykm 2020-11-25T16:16:04Z Re: Logic required https://community.qlik.com/t5/QlikView/Logic-required/m-p/1397373#M802809 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>what is the rule to map the codes and the users ?</P></BODY></HTML> Wed, 15 Nov 2017 16:51:30 GMT https://community.qlik.com/t5/QlikView/Logic-required/m-p/1397373#M802809 YoussefBelloum 2017-11-15T16:51:30Z Re: Logic required https://community.qlik.com/t5/QlikView/Logic-required/m-p/1397374#M802810 <HTML><HEAD></HEAD><BODY><P>May be as below:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183458_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 15 Nov 2017 22:02:15 GMT https://community.qlik.com/t5/QlikView/Logic-required/m-p/1397374#M802810 trdandamudi 2017-11-15T22:02:15Z