topic Re: Imported user filters do not work in Qlik NPrinting

Imported user filters do not work

GabrielaRzeznikiewicz_ — Fri, 15 Nov 2024 20:59:29 GMT

Hi,

I am having troubles with applying user filters on the report. The issue seems to be with data types.

I have an excel file where I import users, their groups, and filters. Filters are applied on customer number field, which is numeric value in the template app, to which I have a connection. However, no matter what I do, and how I format filters in the import file (putting value in single/double quotes, not using quotes), NPrinting always treats it as string not numeric type. This causes NPriniting being unable to apply filters as the format are different in Qlik app and NPrinting and publish task fails.

I can manually change Value part from ‘Value is’ to ‘Numeric Value is’ in the Filter options and that solves the issue but for my project it is crucial to have that automated.

@Lech_Miszkiewicz I heard from my coworker that you might be the right person to ask 😉

Does anybody have any idea how to solve that issue?

Thanks in advance!

Re: Imported user filters do not work

Lech_Miszkiewicz — Thu, 04 Jul 2024 23:29:28 GMT

Hi @GabrielaRzeznikiewicz_

out of all versions you listed which one is the one you are using? Make sure you provide information about the one you have installed as answers may depend on actual version. Now your May 2022 version is out of support so make sure you upgrade to currently supported version!
how did you setup recipient import file? Have you followed instructions from official helps site?
- https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm#anchor-2 - this is for May 2022 version
- this is for current version Feb 2024 - they should be identical! as there were no changes in this area in recent years: https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm#anchor-2
If you look at the links I have provided you see there is a link to sample files (templates). When you download it and extract it and open Recipients.xlsx, navigate to Filters sheet and there you will see clearly the structure of how to enter values, numerical values, Evaluate value (Formulas) or variable and advanced search filters. In your case you simply put values in "Numeric Values" column and thats it.

You have not provided your current spreadsheet screenshot so I can only guess that you guys assumed that filter can only be entered in "Values" column where in fact there are dedicated columns for each type of the filter and for numerical type you need to use the next "Numerical Value" column.

I guess that is a super easy fix - but it begs the question how you guys missed it? 😄

cheers

Lech

Re: Imported user filters do not work

Lech_Miszkiewicz — Thu, 04 Jul 2024 23:31:57 GMT

Just to follow up my previous comment.

Make sure you review your excel import file and compare its structure to the one from help site. You could be having wrong structure modified by someone and unwingly changing available properties?

cheers

Re: Imported user filters do not work

Lech_Miszkiewicz — Mon, 08 Jul 2024 06:34:16 GMT

Hi @GabrielaRzeznikiewicz_

It would be great to hear how did you go with this. Please let us know when you get a chance.

cheers

Re: Imported user filters do not work

GabrielaRzeznikiewicz_ — Mon, 08 Jul 2024 08:57:33 GMT

Hi,

Thanks a lot! I have no idea how we missed it but changing the column name to "Numeric Values" helped.

Best,

Gabriela

Re: Imported user filters do not work

Lech_Miszkiewicz — Mon, 08 Jul 2024 09:17:44 GMT

That is good news. Make sure you keep the structure of the file (all columns in it) as per the one from sample files. You then just put values which must be numerical in numerical value columns, strings into value column etc...

anyway - I am glad we could help.

cheers