topic Re: Cell value about in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364782#M18092 <HTML><HEAD></HEAD><BODY><P>Here you go <STRONG style="text-decoration: underline;"><BR /></STRONG></P><P><STRONG style="text-decoration: underline;"><BR /></STRONG></P><P><STRONG style="text-decoration: underline;">Front End</STRONG></P><P><STRONG>Concat([Clomn1(Policy)],'-')</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG style="text-decoration: underline;">In Script</STRONG></P><P><STRONG>LOAD Concat([Clomn1(Policy)],'-') as Col1 ,&nbsp; [Clomn2&nbsp; (ID)] as Col2 Group By [Clomn2&nbsp; (ID)];</STRONG></P><P>LOAD * Inline [</P><P>Clomn1(Policy),&nbsp; Clomn2&nbsp; (ID)</P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111</P><P>YY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111</P><P>ZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 222</P><P>MM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 222</P><P>];</P><P><STRONG><BR /></STRONG></P></BODY></HTML> Wed, 31 May 2017 09:17:17 GMT Anil_Babu_Samineni 2017-05-31T09:17:17Z Cell value about https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364781#M18091 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I've a problem.Can you help me please.</P><P></P><P>I've a table</P><P>Clomn1(Policy)&nbsp;&nbsp; Clomn2&nbsp; (ID)&nbsp; </P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111</P><P>YY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111</P><P>ZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 222</P><P>MM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 222</P><P></P><P>How can we do the following table?</P><P></P><P>Clomn2(ID)&nbsp;&nbsp; Clomn1(Policy)&nbsp; </P><P>111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; XX-YY</P><P>222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ZZ-MM</P><P></P><P>thank you so much...</P></BODY></HTML> Wed, 31 May 2017 08:15:35 GMT https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364781#M18091 mert1917 2017-05-31T08:15:35Z Re: Cell value about https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364782#M18092 <HTML><HEAD></HEAD><BODY><P>Here you go <STRONG style="text-decoration: underline;"><BR /></STRONG></P><P><STRONG style="text-decoration: underline;"><BR /></STRONG></P><P><STRONG style="text-decoration: underline;">Front End</STRONG></P><P><STRONG>Concat([Clomn1(Policy)],'-')</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG style="text-decoration: underline;">In Script</STRONG></P><P><STRONG>LOAD Concat([Clomn1(Policy)],'-') as Col1 ,&nbsp; [Clomn2&nbsp; (ID)] as Col2 Group By [Clomn2&nbsp; (ID)];</STRONG></P><P>LOAD * Inline [</P><P>Clomn1(Policy),&nbsp; Clomn2&nbsp; (ID)</P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111</P><P>YY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111</P><P>ZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 222</P><P>MM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 222</P><P>];</P><P><STRONG><BR /></STRONG></P></BODY></HTML> Wed, 31 May 2017 09:17:17 GMT https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364782#M18092 Anil_Babu_Samineni 2017-05-31T09:17:17Z Re: Cell value about https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364783#M18093 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Like this</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P>T1:</P><P>LOAD * Inline [</P><P>Policy ,&nbsp; ID </P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,111</P><P>YY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,111</P><P>ZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,222</P><P>MM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,222</P><P><SPAN style="font-size: 10pt;">];</SPAN></P><P>NoConcatenate</P><P>T2:</P><P>LOAD</P><P>Concat(Policy,'-') as Policy,</P><P>ID</P><P><SPAN style="font-size: 10pt;">Resident T1 Group by ID;</SPAN></P><P>DROP Table T1;</P></BODY></HTML> Wed, 31 May 2017 10:05:46 GMT https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364783#M18093 qlikview979 2017-05-31T10:05:46Z Re: Cell value about https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364784#M18094 <HTML><HEAD></HEAD><BODY><P>Thank you so much Anil <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>have a nice day</P></BODY></HTML> Wed, 31 May 2017 11:03:33 GMT https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364784#M18094 mert1917 2017-05-31T11:03:33Z Re: Cell value about https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364785#M18095 <HTML><HEAD></HEAD><BODY><P>Thank you so Mahesh <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>have a nice day</P></BODY></HTML> Wed, 31 May 2017 11:04:29 GMT https://community.qlik.com/t5/Qlik-NPrinting/Cell-value-about/m-p/1364785#M18095 mert1917 2017-05-31T11:04:29Z