Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
erikzions
Creator
Creator

Nprinting Multiple Dynamic Values in a Filter

I have a snap shot of my data for each month.  I have a chart that will display whatever dates are selected.  I need to export that chart with the current date, last quarter and last December selected.  I have three variables to identify the needed as of dates. It works if I only have one date, So how do I add more?  I can do it with static values, but not with my variables.  I am sure I am missing something simple.

This is an image of what I am trying to accomplish.

Capture.PNG

Thanks

1 Solution

Accepted Solutions
erikzions
Creator
Creator
Author

The solution was that I had some variables defined in the dashboard and other in Nprinting.  It would not assign all the values until I made them all in Qlikview.  Then I was able to apply multiple dynamic values to a single filter based on variables.  Thank you all for your help

View solution in original post

6 Replies
Frank_S
Support
Support

If I understand your objective correctly, you can use object level filtering to achieve the result you are looking for.

Check this tutorial for more information.

How to Apply a Specific Filter to Tables or Images

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
erikzions
Creator
Creator
Author

The question was not how to apply a filter, but how to create a filter that will apply more than one dynamic value.

Frank_S
Support
Support

You will need to create a dynamic 'variable' filter.

Choose the 'variable' option rather than the field option

Add your calculation value and select calculate as shown in the image below.

dynamic variable filter.PNG

If you need the data in your chart to change based on the variable filter, you can follow this tutorial.

Set a QlikView Variable to a Specific Value Using Filters

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
erikzions
Creator
Creator
Author

I already have the variables with their correct values.  I am trying to apply filters based on the values in the variables.  I can apply a filter for a date field with three values if I enumerate the exact values. 

For example, if the filter assigns the dates "June", "July", and "September" it would work fine. 

But if the filter assigns the dates $(vMonth1), $(vMonth2), and $(vMonth3) it fails to apply the selections.

If this is not possible, I am sorry for wasting your time.

Daniel_Jenkins
Specialist III
Specialist III

Hi Erik,

Taking your most recent example, if your chart and variables in your QlikView document look something like this:

And you want your NPrinting Excel report with the above table filtered like this:

Your NPrinting Field type filter definition would look like this:

I have attached a sample project. Please extract to folder C:\Temp\Community\014 in order to preserve the paths used or you will need to change them manually in the NSQ.

HTH - Daniel.

erikzions
Creator
Creator
Author

The solution was that I had some variables defined in the dashboard and other in Nprinting.  It would not assign all the values until I made them all in Qlikview.  Then I was able to apply multiple dynamic values to a single filter based on variables.  Thank you all for your help