Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Filtering with list variable

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?

1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

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

View solution in original post

11 Replies
Highlighted

NPrinting does not support triggers.

In fact the latest release will disable them entirely.

Highlighted
Not applicable

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.

Highlighted

Have you tried this (without dollar sign expansion)?

=vMonthList

Highlighted

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 ??

Highlighted
Not applicable

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

Highlighted
Not applicable

Doesn't work

I'm using

=$(vDefaultYear)

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

Highlighted

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

Highlighted
Not applicable

They will not

Highlighted
Creator III
Creator III

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