Pixel Perfect Filter issue

[vitaliichupryna]

Hi,

I'm working on the Pixel Perfect report, in my report I have a few levels, everything works good, but I have issue with filter.

In my data model I have three tables, I want apply filter on ReportName field, currently it contains 5 names

The most strange thing: when I load all data in report I can apply filter only on one value - it always the same.

When I load only one report for example  ReportName = Europe, I can run report without filter, but when I apply filter ReportName = Europe I receive issue.

I removed my user filters, also in all report it's only one filter, so I can't find reason of the issue.

Do you have any ideas?

Thanks,

Vitalii

[Ruggero_Piccoli]

Hi,

You are applying an invalid filter. Refresh the connection cache and be sure that the value you are using in the filter is present in the source data. Then check all filters applied to task, report and user to be sure that there are not incompatible values.

Best Regards,

Ruggero

[vitaliichupryna]

Hi Ruggero,

I refresh connection cache every time and also checked data in my data model, but still have issue.

Also I found that I can receive data for every report when I change filter to StrategicCallReport (is the name of report that always run correctly)

In my data model I run load with parameters , for example:

MeetingsAll, CSOL PPP Period 2019, Subregion2, N/A, N/A, N/A, Y, N

StrategCallAll, CSOL PPP Period 2019, All, N/A, N/A, N/A, Y, Y

When I change MettingsAll to StrategCallAll I receive correct data in the report, so looks like 'StrategCallAll' is saved in Nprinting as correct filter name

Could you check if I refresh connection cache correctly:

1. Refresh application

2. Open connection

3. Click reload metadata

Also I tried 'Run verification' in the connection menu, but receive following issue:

Errors detected. Check details below.

 The "Identity" and the Qlik NPrinting Engine service account are a Windows domain user.

In your opinion can this issue affect filters?

Thanks,

Vitalii 

[Ruggero_Piccoli]

Hi,

You must fill all the requirements. Refer to https://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/DeployingQVNprinting/User-accounts.....

All checks in the run verification must be green. It could be the reason of the issue.

Best Regards,

Ruggero

[vitaliichupryna]

I've fixed issue with verification, but issue still exists. Looks like it's a bug

[vitaliichupryna · Accepted solution]

Finally, I've found the reason of issue.

In my application I had variable with name 'ReportName' with value StrategCallAll. I changed name of variable and report runs correctly.

So Filter field name shouldn't match with variables in the application

Thanks,

Vitalii

[Ruggero_Piccoli]

Hi,

Do you have values for ReportName = Europe in the source Qlik Sense app?

Has the app section access? If yes, the user in the Qlik NPrinting connection has access to all values of the app or is it filtered?

Best Regards,

Ruggero