topic Re: Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023085#M639583 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Thu, 31 Mar 2016 08:46:25 GMT t_chetirbok 2016-03-31T08:46:25Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023079#M639577 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a table.</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119980_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Need result with ManagerNames</P><P></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/119984_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Thu, 31 Mar 2016 07:31:31 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023079#M639577 help4qv123 2016-03-31T07:31:31Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023080#M639578 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>Find the attachment</P></BODY></HTML> Thu, 31 Mar 2016 07:34:08 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023080#M639578 t_chetirbok 2016-03-31T07:34:08Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023081#M639579 <HTML><HEAD></HEAD><BODY><P>Thank You..My actual table has more than 2 columns...i cant use apply map function. is there any other way without using applymap..</P></BODY></HTML> Thu, 31 Mar 2016 07:43:03 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023081#M639579 help4qv123 2016-03-31T07:43:03Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023082#M639580 <HTML><HEAD></HEAD><BODY><P>for creating Map you need just write your two field from all data</P><P></P><P>MAP:</P><P>Mapping</P><P>LOAD&nbsp; Emp_id, Emp_Name from Source;</P></BODY></HTML> Thu, 31 Mar 2016 07:45:42 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023082#M639580 t_chetirbok 2016-03-31T07:45:42Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023083#M639581 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this..</P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">T1:<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">LOAD</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">&nbsp; * </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">INLINE</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[<BR /> Emp_id, Emp_Name, Manager_id<BR /> 1, A, 1<BR /> 2, B, 1<BR /> 3, C, 2<BR /> 4, D, 3<BR /> 5, E, 3<BR /> 6, F, 4<BR /> 7, G, 5<BR /> ]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">;<BR /> <BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Left</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Join</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(T1) <BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">LOAD</STRONG> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Emp_id</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">as</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Manager_id</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Emp_Name</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">as</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Manager_Name</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Resident</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> T1;</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><IMG alt="Capture1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119987_Capture1.JPG" style="height: auto;" /><BR /></SPAN></P></BODY></HTML> Thu, 31 Mar 2016 07:56:32 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023083#M639581 settu_periasamy 2016-03-31T07:56:32Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023084#M639582 <HTML><HEAD></HEAD><BODY><P>Thank You...:)</P></BODY></HTML> Thu, 31 Mar 2016 08:43:54 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023084#M639582 help4qv123 2016-03-31T08:43:54Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023085#M639583 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Thu, 31 Mar 2016 08:46:25 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1023085#M639583 t_chetirbok 2016-03-31T08:46:25Z