Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Contributor II

nPrinting formula

Hi Guys,

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.

I am getting the result but i need a space in between the first cell value and second cell value.

Header 1Date
Report Ending on 6/3/2016

the formula looks like =Header 1 & Date(Date,"D-MMM") and the output is Report Ending on6/3/2016.

But how get the space after the on and it should look like Report Ending on 6/3/2016.



Tags (1)
1 Reply
Contributor II

Re: nPrinting formula

Hi, I got the solution. You need to add single quotes instead of double quotes to get space

Community Browser