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.

[fkeuroglian]

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.

[#3]

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

[fkeuroglian]

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

[Stephen_Jasionowski]

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?

[fkeuroglian]

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.

[Daniel_Jenkins]

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.

[Stephen_Jasionowski]

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.

[fkeuroglian]

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.

[#10]

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

[#11]

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?