topic Re: Dynamic column headers in Qlik NPrinting

Dynamic column headers

curiousfellow — Wed, 20 Feb 2019 08:31:22 GMT

For example:

In Qlik I have a variable called thisyear

In a chart I have an expression with label ='Sales in '& $(thisyear)

works fine. But when I use the chart in Nprinting columnheaders show the expression and not it's result.

I insert the chart as a table in Nprinting.

In this thread https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-17-dynamic-field-names/td-p/85732

user seems to get the result of a calculated label as Column header in Nprinting.

In my case i get the expression itself as columnheader, should I change something in Nprinting designer ?

Re: Dynamic column headers

pradosh_thakur — Wed, 20 Feb 2019 08:49:03 GMT

Hi @curiousfellow

I think there should be no issues . Try using ='Sales in '& $(thisyear) or ='Sales in '& $(=thisyear) in QV and darag and drop in Nprinting. If it doesn't work. get the variable in nprinting or create a formuale , the delete the default header and use

='Sales in ' & variable_imported_in_nprinting/formuale written in Nprinting

Re: Dynamic column headers

curiousfellow — Wed, 20 Feb 2019 09:09:08 GMT

I cannot see where your expression differs from mine. ='Sales in '& $(=thisyear) does not work.
Creating new variables in Nprinting is something I like to avoid, because it is double work isn't it ?

Re: Dynamic column headers

pradosh_thakur — Wed, 20 Feb 2019 09:18:14 GMT

You can import the variable already created in Qlikview into Nprinting and i don't think that will have much impact unless you have too many. I am not saying my expression is different the yours. I

Re: Dynamic column headers

curiousfellow — Wed, 20 Feb 2019 09:21:26 GMT

Sorry, I did not mean creating new variables, I meant creating new expressions to show correct columnheaders, while they allready in exist in Qlik.

Appreciate your help by the way 🙂

Re: Dynamic column headers

pradosh_thakur — Wed, 20 Feb 2019 09:34:03 GMT

Ok . so if you want to use Qlik variable only and not to import them in nprinting, just drag that column and see the output, not the preview. If this doesn't work you have no options but to import the variable in Nprinting . You dont have to create the expression.

I think it will so expression only and will not be dynamic if you drag the column header.

Re: Dynamic column headers

Ruggero_Piccoli — Wed, 20 Feb 2019 09:42:25 GMT

Hi,

As general rule, when you post please always specify the version of Qlik NPrinting you are using, the type of connection and the type of report you are developing.

In any case you have two possible solutions:

- create a variable in Qlik, import it in Qlik NPrinting and drag and drop it a column name

- create a Qlik NPrinting formula and drag and drop it as column name

Best Regards,

Ruggero

Re: Dynamic column headers

curiousfellow — Wed, 20 Feb 2019 10:02:07 GMT

I am sorry not to be complete.

We are using Nprinting 17.6.0000.0 (Yes I know it is a very old version, due to shortage of manpower we did not upgrade yet, but will soon)

I am creating an excel report, and it is a local connection.

@Ruggero_Piccoli This is indeed the way I usually create dynamic headers, but because I saw calculated headers in the thread that I mentioned first, I thought there was a way to use the calculated headers.

Thank you both.