topic nPrinting formula in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/nPrinting-formula/m-p/1131968#M10760 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P>I have tow colums like below and i am trying to create a formula in nPrinting to merge both the cells and get the concatenated value.</P><P>I am getting the result but i need a space in between the first cell value and second cell value.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH></TR><TR><TD style="padding: 2px;">Report Ending on </TD><TD style="padding: 2px;">6/3/2016</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>the formula looks like =Header 1 &amp; Date(Date,"D-MMM") and the output is Report Ending on6/3/2016.</P><P>But how get the space after the on and it should look like <SPAN style="font-size: 13.3333px;"><STRONG>Report Ending on 6/3/2016</STRONG>.</SPAN></P><P></P><P>thanks,</P><P>Viresh</P></BODY></HTML> Thu, 16 Jun 2016 12:37:42 GMT vireshkolagimat 2016-06-16T12:37:42Z nPrinting formula https://community.qlik.com/t5/Qlik-NPrinting/nPrinting-formula/m-p/1131968#M10760 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P>I have tow colums like below and i am trying to create a formula in nPrinting to merge both the cells and get the concatenated value.</P><P>I am getting the result but i need a space in between the first cell value and second cell value.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH></TR><TR><TD style="padding: 2px;">Report Ending on </TD><TD style="padding: 2px;">6/3/2016</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>the formula looks like =Header 1 &amp; Date(Date,"D-MMM") and the output is Report Ending on6/3/2016.</P><P>But how get the space after the on and it should look like <SPAN style="font-size: 13.3333px;"><STRONG>Report Ending on 6/3/2016</STRONG>.</SPAN></P><P></P><P>thanks,</P><P>Viresh</P></BODY></HTML> Thu, 16 Jun 2016 12:37:42 GMT https://community.qlik.com/t5/Qlik-NPrinting/nPrinting-formula/m-p/1131968#M10760 vireshkolagimat 2016-06-16T12:37:42Z Re: nPrinting formula https://community.qlik.com/t5/Qlik-NPrinting/nPrinting-formula/m-p/1131969#M10761 <HTML><HEAD></HEAD><BODY><P>Hi, I got the solution. You need to add single quotes instead of double quotes to get space</P></BODY></HTML> Thu, 16 Jun 2016 12:59:24 GMT https://community.qlik.com/t5/Qlik-NPrinting/nPrinting-formula/m-p/1131969#M10761 vireshkolagimat 2016-06-16T12:59:24Z