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
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 ?
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
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.
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
Best Regards, Ruggero --------------------------------------------- When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
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.
