Nprinting filters > value

[fkeuroglian]

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.

[Stephen_Jasionowski · Accepted solution]

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

[jyothish8807]

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

[#4]

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

[Stephen_Jasionowski]

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.

[fkeuroglian]

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.

[Stephen_Jasionowski]

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

[fkeuroglian]

I am testing right now!

Thank you a lot

Fernando K.

[fkeuroglian]

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

[#10]

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