Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
mstoler
Partner - Specialist
Partner - Specialist

excel report with dynamic column names

Hello,

I am creating an excel report where the column labels are expressions ('Current Year ' & vYear).

The labels work fine in QlikView but in the NPrinting report I get the expression instead of the value.

How do I get NPrinting to evaluate the expression for the column labels?

I am using NPrinting 16.

Thank You,

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

you have couple of option

1. if you use the whole table , drag and drop the whole table tag ,that way you'll get exactly what you see in qlikview

2. drag and drop the desired columns , copy the expression form the columns headers and create new functions

with those expressions , replace the headers formula with the expressions

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

you have couple of option

1. if you use the whole table , drag and drop the whole table tag ,that way you'll get exactly what you see in qlikview

2. drag and drop the desired columns , copy the expression form the columns headers and create new functions

with those expressions , replace the headers formula with the expressions

mstoler
Partner - Specialist
Partner - Specialist
Author

Hello,

Thank You.

I was also able to create variables in Qlik and then use the variables.