Imported user filters do not work

[GabrielaRzeznikiewicz_]

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!

[Lech_Miszkiewicz · Accepted solution]

Hi @GabrielaRzeznikiewicz_ 

1. 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!
2. 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-Fi... - 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-Use...
3. 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

[Lech_Miszkiewicz]

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

[Lech_Miszkiewicz]

Hi @GabrielaRzeznikiewicz_ 

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

cheers

[GabrielaRzeznikiewicz_]

Hi,

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

Best,

Gabriela

[Lech_Miszkiewicz]

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