Qlik NPrinting Concatenation in Excel Template

[Anonymous]

Hello,

Could someone explain to me how to use Excel concatenation to bring together 2 columns in NPrinting? I have the formula working; however, when I place it inside, it begins below the populated cells that my excel report generate. I am able to concatenate the first grouping (placing the formula to point at the cells where the qlik nprinting tag is), but I cannot seem to get it to work in a column to the right. What I am after is...

Column 1:   Column 2:   Column 3:

A                 1                  A1

B                 2                  B2

C                 3                  C3

...

With NPrinting making it work...

Thanks everyone!

[hopkinsc]

Hi, what does your template look like? are you able to upload it?

[Anonymous]

unfortunately,

I cannot upload this one. The template is very basic just with about 6 columns and NPrinting tags that generate about 180 rows of data that is all. Do you need more info?

Thanks

[Anonymous · Accepted solution]

Chris, I was able to solve the issue. I created an additional column that was setup to concatenate the qlik sense dimension tags and it populated all the way down the sheet. Thanks for your itme