Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Partner
Partner

Nprinting filters > value

Hi Expert

I want to create a filter in nprinting that only show if the dias Mora > 822, What is the correct way to create this filter, is possible?

thank you a lot

Attach image that i created a filter to show

Thank you a lot

Fernando K.

1 Solution

Accepted Solutions

Re: Nprinting filters > value

Fernando -

Your best bet may be to create this filter in QlikView as a bookmark with a dynamic search expression. See the following tutorial: How to Create QlikView Bookmark Filters Using Dynamic Search Expressions

View solution in original post

21 Replies

Re: Nprinting filters > value

Fernando -

Your best bet may be to create this filter in QlikView as a bookmark with a dynamic search expression. See the following tutorial: How to Create QlikView Bookmark Filters Using Dynamic Search Expressions

View solution in original post

jyothish8807
Honored Contributor II

Re: Nprinting filters > value

Hi Fernando,

Try to apply the >822 filter at QV level and export the chart in Nprinting, so you can avoid this filter. I am not sure if you can create a customized filter in Nprinting. Solution suggested by @Stephen should work, its new for me also.

Thanks for the share stephen

Regards

KC

Best Regards,
KC
Not applicable

Re: Nprinting filters > value

another option in additiona to Stephen's suggetion is to create a filter in Nprinting but isntead of selecting a value from a lsit of fields, you can write your own expression within the filter

Re: Nprinting filters > value

Please note that if you take this approach, the expression in the filter can only return a single value, not an array.

So in the case where you are looking for all Mora > 822, this cannot be done with an expression inside the NPrinting filter.

Partner
Partner

Re: Nprinting filters > value

Hi stephen, but if i want all that > 822, (more than 1 result) it can be done using a bookmark as you said at first?

thank you a lot

Fernando K.

Re: Nprinting filters > value

Yes, in that case the bookmark filter can return an array of dynamic values based on the expression you use in QlikView

Partner
Partner

Re: Nprinting filters > value

I am testing right now!

Thank you a lot

Fernando K.

Partner
Partner

Re: Nprinting filters > value

Hi Stephen, one more question

i create the filter base in the bookmark, now i see the object in my excel report but i see empty, is there any way that the object DO NOT APPEAR if the value is less than xxx value?


see the image attached to see how i see now, i only want the chart if it is for example more than >822


thank you a lot.


Fernando

Not applicable

Re: Nprinting filters > value

There is a verify filter option that will only create the report if there is data.  You can possibly create a condition for the report and only send it out if the condition is met/not met, usch as whether or not there are items in an object/chart