Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
I would suggest the verify filter option - if there is no data for the report, it should not be created
Adam is there any way to verify a filter based in a bookmark?
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?
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.
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.
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.
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.
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
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?