topic Re: excel report with dynamic column names in Qlik NPrinting

excel report with dynamic column names

mstoler — Tue, 29 Nov 2016 19:47:20 GMT

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,

lironbaram — Tue, 29 Nov 2016 20:22:31 GMT

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 — Tue, 29 Nov 2016 20:31:07 GMT

Hello,

Thank You.

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