Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-03-22 10:45 AM

NPrinting filter using variables

Hello,

what I'm trying to do is dynamic filter based on the selections of the user in the filters object of Sense.

I created a variable in Sense called vSelected and using the function getFieldSelections, I was able to print the selections in Sense.

Then I tried to use the same variabe in a filter of NPrinting (Feb 2018) but also using "evluate field" I was not able to make it works.

I tried using $(vSelected), '$(vSelected)' but at the moment I was not able to find the solution to my problem. I'm always having error during the NPrinting report preview. I cannot use static filter because of the numbers I'm dealing with.

I hope someone can help me.

Thanks a lot in advance .

1,699 Views
0 Likes
1 Reply
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2018-03-22 08:16 PM

Hi,

i think you need to provide us with more structured description as above is actualy very unclear.

Could you please screenshot:

  • your variable formula in Qlik Sense
  • what is it required output when evaluated in qlik sense
  • how do you evaluate it (do you apply any selections in Qlik Sense? - screenshot selections you apply)
  • screenshot how you put your variable in NPrinting filter and describe what it meant to do.

Keep in mind that filter in NPrinintg has to point to a single value, so if you variable returnes multiple values your nprinitng filter will NEVER work:

also read all this:

https://help.qlik.com/en-US/nprinting/February2018/Content/ReportsDevelopment/Static-dynamic-filters...

https://help.qlik.com/en-US/nprinting/February2018/Content/Troubleshooting/Variables-dont-expand-bef...

Lech

---------------------------------------------

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

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.
1,283 Views
0 Likes