topic Re: Filtering with list variable in Qlik NPrinting

Filtering with list variable

Wed, 28 Sep 2016 11:37:14 GMT

Hi,

I know I can use list variable in OnOpen script to set the months I want to have selected with

LET vMonthList = '(1|2|3)';

And using

='$(vMonthList)'

In OnOpen trigger

But I can't seem to get this to work when using filters in NPrinting. I have tried

=$(vMonthList)

='$(vMonthList)'

But I just can't figure the correct syntax to make the list variable work as filter value.

What syntax should I use?

Re: Filtering with list variable

Stephen_Jasionowski — Wed, 28 Sep 2016 11:40:36 GMT

NPrinting does not support triggers.

In fact the latest release will disable them entirely.

Re: Filtering with list variable

Wed, 28 Sep 2016 11:43:16 GMT

Hi Stephen,

Yes I know I can't use the trigger with NPrinting, it's only used for people viewing the document the reqular way.

I'm using NPrinting filters when creating an HTML report of the document. List variable works as an OnOpen field select trigger, but not as a NPrinting filter.

Re: Filtering with list variable

sunny_talwar — Wed, 28 Sep 2016 11:44:43 GMT

Have you tried this (without dollar sign expansion)?

=vMonthList

Re: Filtering with list variable

avinashelite — Wed, 28 Sep 2016 11:44:56 GMT

Since you have the OnOpen triggers , when the NPrinting open the QVW by default it will apply the filter rite ?? then whats the need to apply it again ??

Re: Filtering with list variable

Wed, 28 Sep 2016 11:49:13 GMT

NPrinting doesn't support triggers, so I need to use the Nprinting Filters functionality.

Re: Filtering with list variable

Wed, 28 Sep 2016 11:51:45 GMT

Doesn't work

I'm using

=$(vDefaultYear)

To select the correct year, and that syntax works for selecting a single year.

Re: Filtering with list variable

avinashelite — Wed, 28 Sep 2016 11:54:11 GMT

You mean triggers will not work when opening the QV document from NPrinting app ??

Re: Filtering with list variable

Wed, 28 Sep 2016 11:58:02 GMT

They will not

Re: Filtering with list variable

harishkumarg — Wed, 28 Sep 2016 12:53:45 GMT

Hi Mika Lindman

Document OnOpen trigger is working in NPrinting for me. I am using v16.3

As Avinash said NPrinting NSQ will open the QVW and the OnOpen trigger will be set to QVW.

Please let me know if need my sample NSQ and QVW.

Regards

Harish

Re: Filtering with list variable

Thu, 29 Sep 2016 03:53:27 GMT

I know triggers have worked atleast to some extend on the earlier versions, but as Stephen said earlier

NPrinting does not support triggers.

In fact the latest release will disable them entirely.

Naturally I want to use a solution that will work on current future versions.

Re: Filtering with list variable

rong — Mon, 23 Jan 2017 10:02:49 GMT

You have to repeat the dimension you need to filter on in the value field.

Here's what I use to filter on the current Posting Quarter (fiscal quarter):

=[Posting Quarter]=vThisFQ