Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

erikzions
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
erikzions
Contributor

Re: Nprinting Multiple Dynamic Values in a Filter

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

6 Replies
Employee
Employee

Re: Nprinting Multiple Dynamic Values in a Filter

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

This community user does not receive direct private messages
erikzions
Contributor

Re: Nprinting Multiple Dynamic Values in a Filter

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

Highlighted
Employee
Employee

Re: Nprinting Multiple Dynamic Values in a Filter

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

This community user does not receive direct private messages
erikzions
Contributor

Re: Nprinting Multiple Dynamic Values in a Filter

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.

Employee
Employee

Re: Nprinting Multiple Dynamic Values in a Filter

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
Contributor

Re: Nprinting Multiple Dynamic Values in a Filter

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

Community Browser