Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III

How to use variable in N Printing Power Point report

Hi Experts,

I have to add a Dynamic text box on below Nprinting Power point report as As of 02/04/2020.

For 02/04/2020 I have dragged vMaxReportDate variable to slide but its showing max(Report Date) expression which is the formula of variable but i am looking for 02/04/2020 as the result from that variable. Please help me on this.

Max report date.png

Thanks in advance

Labels (2)
1 Solution

Accepted Solutions
Lech_Miszkiewicz

This is working as designed.

If you want your variable to expand so it produces the result of the formula you should put = sign in its definition "=max(Report Date)" or use formula to expand it in NPrinting using $ sign

I suggest always read documentation first before posting questions here:

variables expansion:

https://help.qlik.com/en-US/nprinting/February2020/Content/NPrinting/Troubleshooting/Variables-dont-...

 

formulas:

https://help.qlik.com/en-US/nprinting/February2020/Content/NPrinting/ReportsDevelopment/Formulas.htm

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

3 Replies
Lech_Miszkiewicz

This is working as designed.

If you want your variable to expand so it produces the result of the formula you should put = sign in its definition "=max(Report Date)" or use formula to expand it in NPrinting using $ sign

I suggest always read documentation first before posting questions here:

variables expansion:

https://help.qlik.com/en-US/nprinting/February2020/Content/NPrinting/Troubleshooting/Variables-dont-...

 

formulas:

https://help.qlik.com/en-US/nprinting/February2020/Content/NPrinting/ReportsDevelopment/Formulas.htm

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
pawwy1415
Creator III
Creator III
Author

Hi @Lech_Miszkiewicz 

Formula expansion is working fine. But still variable expansion is not working for me.

I have passed the variables from csv file into qliksense. There is no equal sign on variable definition in CSV file.

In Qliksense apps we have used these variables like =$(vTSCandidatesCount) but in N printing its not Working.

could you please explain with this example how to call in it N Printing from variable expansion.

tscount.png

Preview:

Preview.png

Thanks in advance

NIRAJ472
Partner - Contributor
Partner - Contributor

Hi Pawwy1415,

Use  =$(vTSCandidatesCount) as formula into Formula section under variable Section normally as you would use in Text box in Qlik Sense Front end. but First convert vTSCandidatesCount into text at Variable creation.