topic Re: Nprinting filters > value in Qlik NPrinting

Nprinting filters > value

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

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.

Re: Nprinting filters > value

Stephen_Jasionowski — Tue, 22 Dec 2015 13:53:07 GMT

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

Re: Nprinting filters > value

jyothish8807 — Tue, 22 Dec 2015 14:01:03 GMT

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

Re: Nprinting filters > value

Tue, 22 Dec 2015 14:13:03 GMT

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

Stephen_Jasionowski — Tue, 22 Dec 2015 14:19:59 GMT

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.

Re: Nprinting filters > value

fkeuroglian — Tue, 22 Dec 2015 14:23:17 GMT

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

Stephen_Jasionowski — Tue, 22 Dec 2015 14:47:49 GMT

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

Re: Nprinting filters > value

fkeuroglian — Tue, 22 Dec 2015 14:52:29 GMT

I am testing right now!

Thank you a lot

Fernando K.

Re: Nprinting filters > value

fkeuroglian — Tue, 22 Dec 2015 18:05:40 GMT

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

Re: Nprinting filters > value

Tue, 22 Dec 2015 18:24:50 GMT

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

Re: Nprinting filters > value

fkeuroglian — Tue, 22 Dec 2015 18:33:12 GMT

Hi Adam

I want that the chart do not appear if the result is 0, for example, but in this report, is for each salesman, and i do not want to see in the report if the result is 0, now, i see the object but with zero value.

What do you think could be a good solution?

thank you a lot

Fernando K.

Re: Nprinting filters > value

Tue, 22 Dec 2015 18:34:30 GMT

I would suggest the verify filter option - if there is no data for the report, it should not be created

Re: Nprinting filters > value

fkeuroglian — Tue, 22 Dec 2015 19:05:28 GMT

Adam is there any way to verify a filter based in a bookmark?

Re: Nprinting filters > value

Stephen_Jasionowski — Tue, 22 Dec 2015 19:11:00 GMT

Fernando -

Do you want the report to run only without the empty table, or do you not want the report to be run at all if the table is empty?

Re: Nprinting filters > value

fkeuroglian — Tue, 22 Dec 2015 19:19:01 GMT

Hi Stephen

This is my report for example, i have 2 different salesman, i want that only appear the second salesmen because it has information in the tabler, the first one who do not have information i want to do not appear in the excel report nprinting

thank you for all your help!

Fernando K.

Re: Nprinting filters > value

Daniel_Jenkins — Wed, 23 Dec 2015 00:51:15 GMT

Hi,

Just for the record, you can use a Field filter for >, <, <> etc. to return an array of values using advanced search syntax How to Use QlikView Advanced Search with NPrinting Filters

If your QV chart looks like this:

And in your Excel report you want a result like this (i.e., field DiasMora values > 822😞

Your Field filter would look like this:

Here is the project I used for the above. Extract to C:\Temp\Community\020 or change the paths in the NSQ.

HTH - Daniel.

Another example here.

Re: Nprinting filters > value

Stephen_Jasionowski — Wed, 23 Dec 2015 01:37:27 GMT

Thanks, Daniel for clarifying.

@Fernando - in that case, you are able to apply the Verify Filter property to the filter in NPrinting, as Daniel has illustrated in his screenshot.

Re: Nprinting filters > value

fkeuroglian — Wed, 23 Dec 2015 12:49:37 GMT

Hi Daniel, thanks for your example

one question, i created and apply the filter, but have this error, what could be? the field is writen ok

I try adding the [ ] but have the same effect

see the attached

Fernando K.

Re: Nprinting filters > value

Wed, 23 Dec 2015 16:58:41 GMT

Fernando

I would like to help out but cannot translate the error/warning you are receiving

If you could help me out with the translation, I can try and assist you

Re: Nprinting filters > value

Wed, 23 Dec 2015 16:59:15 GMT

Fernando

I just added your report to a task and ran it - the filter was applied and I did not encounter any warnings or errors?