topic Re: NPrinting Filter Not Filtering in Qlik NPrinting

NPrinting Filter Not Filtering

timothyj — Tue, 30 Oct 2018 19:28:34 GMT

I am creating a simple Excel report that will list all open bills. To do that I am using a simple filter, as I have always done. I create the filter, add the field, then select the value I want to filter for. Evaluate is not checked. Verify Filter is checked. I preview the report from the report window and it does not filter. I filter the report from the task window after removing the report filter and it does not filter. I run it from the desktop and it does not filter. I schedule a time on the server, and it does not filter. I have never had this trouble before. I create a formula using GetCurrentSelections() on the Excel sheet, and it shows it as a current selection, but it does not filter.

There has to be something simple I am overlooking. This is the first NPrinting report on this particular application. It filters fine on the Qlikview app. It just will not filter it in the NPrinting Excel report.

Re: NPrinting Filter Not Filtering

Lech_Miszkiewicz — Tue, 30 Oct 2018 23:12:29 GMT

Hi Timothy,

There migth be many things you could do wrong:

you could detach object from datamodel
maybe alternate states are used which are not supported in NPrinitng
you could use wrong type of data
- for text use text
- for numeric use numeric value
- for dual (which very often on UI is represented by TEXT) use numeric

Please provide version of your software, screenshots of your filter and maybe screenshot of datatype of the field in table viewer + its preview so we can lead you forward.

cheers

Lech

--------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: NPrinting Filter Not Filtering

timothyj — Wed, 31 Oct 2018 00:33:17 GMT

Thanks Lech,

The data is text- 'A', 'O', 'C', and 'X'. I am not using Alternate States. Will look at 'detach object from datamodel' when I get back to work tomorrow. Selection works fine in the QV app. Just so confusing!

Will post more info tomorrow. After I posted this I got dragged into a long meeting. Thanks!

Re: NPrinting Filter Not Filtering

timothyj — Wed, 31 Oct 2018 13:18:01 GMT

I am using Qlikview Version 11.20.

NPrinting 16.8.

I started from scratch this morning. Saved new nsq file. Loaded template into a new report. I added two filters to that report- Bill Status of 'O' and a Flag of 1. I ran a preview of the excel report, and everything worked perfectly. Exactly once. I ran a test from a task and the report produced but did not filter. (I did not add filters to the task since they are on the report.) Now when I preview, it does not filter either. Again, it filters correctly exactly once, and then it will not filter again. This happened with the last two versions I created. I am really frustrated. This is odd behavior, to work once and then not again.

I have a bunch of other NPrinting reports that run from two different nsq files to different qvws. They are running and filtering just fine. The qvw this one connects to seems to be running just fine. *sigh*

Re: NPrinting Filter Not Filtering

Ruggero_Piccoli — Wed, 31 Oct 2018 13:30:46 GMT

Hi,

Please be sure that the filter is applied in only one point. For example as a report filter. If you apply the same filter two times it is like to press to the same value of the same field two times in QlikView Desktop. It will remove the filter.

Be sure that you create the filter on the same connection of the fields you are using in the template. I think it is not your case but I want to be sure.

Open the Windows Session 0 monitor while the report is generating. You will see QlikView Desktop open and applying the filters. Sometimes this is useful to understand what is happening.

Be sure that the values you are filtering exist in the original document.

Be sure to have Verify filter checked.

We don't have know issues on applying filters in Qlik NPrinting 16.8 so I suppose something is happening in your specific installation. Having some screenshots will help to understand.

Best Regards,

Ruggero

---------------------------------------------

Re: NPrinting Filter Not Filtering

timothyj — Wed, 31 Oct 2018 14:34:26 GMT

Thanks for the response.

The filters are only applied as report filters.

There is only one connection. The report and filters come from the same data model / qvw.

I do not have Windows Session 0 setup on my computer. I will have to get with IS on that. This is the log. The filters appears to be working fine, except they are not.

I am selecting the values through the NPrinting interface. They do exist. They work once. Then they stop.

What screenshots would you like to see?

Thanks again!

Re: NPrinting Filter Not Filtering

Ruggero_Piccoli — Wed, 31 Oct 2018 14:45:28 GMT

Hi,

I would to see the setting of the filter. Thanks.

Best Regards,

Ruggero

---------------------------------------------

Re: NPrinting Filter Not Filtering

timothyj — Wed, 31 Oct 2018 14:54:43 GMT

Re: NPrinting Filter Not Filtering

timothyj — Wed, 31 Oct 2018 14:56:09 GMT

Added, but not as a direct reply. Sorry.

Re: NPrinting Filter Not Filtering

Ruggero_Piccoli — Wed, 31 Oct 2018 15:01:22 GMT

In the first one the Is Numeric flag is not checked.

In the second it correctly is.

Could be this?

Best Regards,

Ruggero

---------------------------------------------

Re: NPrinting Filter Not Filtering

timothyj — Wed, 31 Oct 2018 15:18:18 GMT

The first one is not a numeral, but the letter 'O'. I double checked that a

few times to be sure.

Thanks,

Tim

On Wed, Oct 31, 2018 at 11:09 AM Ruggero Piccoli <qcwebmaster@qlikview.com>

Re: NPrinting Filter Not Filtering

Ruggero_Piccoli — Wed, 31 Oct 2018 15:32:06 GMT

Good. I have no other ideas about what to check.

I suggest you to open a support ticket so a support guy can connect with you and continue the investigation on you computer. Or you can send your environment so they can try to reproduce to understand the reason.

Best Regards,

Ruggero

---------------------------------------------

Re: NPrinting Filter Not Filtering

Lech_Miszkiewicz — Wed, 31 Oct 2018 23:52:22 GMT

I have couple ideas...

do you have any triggers or actions in this qvw which could mess up with filters
do you have any macros?

above mentioned are not supported in NPrinting and might lead to unexpected behavior

regards

Lech

Re: NPrinting Filter Not Filtering

timothyj — Thu, 01 Nov 2018 15:42:37 GMT

Hey Lech,

No macros or triggers. That is why this is so confusing. It is a simple little Excel report where the filters will work exactly once. Driving me nuts!

I have been talking to my IS department. I think I will be using this as the motivation to go ahead and upgrade Qlikview and NPrinting to the latest versions.

Thanks,

Tim

Re: NPrinting Filter Not Filtering

boopeshj — Mon, 23 Mar 2020 18:53:50 GMT

Did you find any solution?

I am facing a similar issue.

My software version :

Qlikview 12.0

Qlik NPrinting February 2019 SR1 [Version: 19.0.4.0]

Re: NPrinting Filter Not Filtering

boopeshj — Mon, 23 Mar 2020 18:58:22 GMT

@Ruggero_Piccoli

Could you please let me know how to check a session 0 ?

Re: NPrinting Filter Not Filtering

Lech_Miszkiewicz — Mon, 23 Mar 2020 23:12:01 GMT

co'mon @boopeshj, why don't you "google" it?

Re: NPrinting Filter Not Filtering

Ruggero_Piccoli — Tue, 24 Mar 2020 07:33:47 GMT

Hi,

I agree with @Lech_Miszkiewicz . Session 0 is related to Microsoft operating system so I suggest you to refer to official Microsoft documentation of the Windows version you are using.

Then please note this is an old conversation related to QlikView NPrinting 16, instead you are using a Qlik NPrinting 17+ version. So, in similar cases please open a new conversation.

Best Regards,

Ruggero

Re: NPrinting Filter Not Filtering

boopeshj — Wed, 25 Mar 2020 06:54:18 GMT

@Lech_Miszkiewicz
Thanks I did Google it before posting here got a lot of results. But thought as @Ruggero_Piccoli it is easier to get to understand.

Re: NPrinting Filter Not Filtering

boopeshj — Wed, 25 Mar 2020 06:56:49 GMT

Btw : After some own trial and error research found out that using text instead of numeric value for the field helped in my case to solve the problem.

eg I was trying to use a filter on the Flag which had values 1,0 .

But now changed it to Yes and No . This helped me. Posting it for others reference.