topic Re: Nprinting Multiple Dynamic Values in a Filter in Qlik NPrinting

Nprinting Multiple Dynamic Values in a Filter

erikzions — Wed, 25 Sep 2019 18:40:54 GMT

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.

Thanks

Re: Nprinting Multiple Dynamic Values in a Filter

Frank_S — Fri, 20 Nov 2015 18:33:30 GMT

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

Re: Nprinting Multiple Dynamic Values in a Filter

erikzions — Fri, 20 Nov 2015 21:35:12 GMT

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

Re: Nprinting Multiple Dynamic Values in a Filter

Frank_S — Fri, 20 Nov 2015 22:57:53 GMT

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.

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

Re: Nprinting Multiple Dynamic Values in a Filter

erikzions — Fri, 20 Nov 2015 23:14:32 GMT

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.

Re: Nprinting Multiple Dynamic Values in a Filter

Daniel_Jenkins — Mon, 23 Nov 2015 01:39:19 GMT

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.

Re: Nprinting Multiple Dynamic Values in a Filter

erikzions — Tue, 16 Feb 2016 23:31:20 GMT

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