Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

rglenn0780
Contributor

Qlik NPrinting Concatenation in Excel Template

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!

Tags (1)
1 Solution

Accepted Solutions
rglenn0780
Contributor

Re: Qlik NPrinting Concatenation in Excel Template

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

3 Replies
hopkinsc
Valued Contributor II

Re: Qlik NPrinting Concatenation in Excel Template

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

rglenn0780
Contributor

Re: Qlik NPrinting Concatenation in Excel Template

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

rglenn0780
Contributor

Re: Qlik NPrinting Concatenation in Excel Template

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

Community Browser