topic Re: NP19 Importing Filters with Overridden Values in Qlik NPrinting

NP19 Importing Filters with Overridden Values

Labiqa — Thu, 02 Jul 2020 18:20:46 GMT

Hi I am using NPrinting19 to create reports and have been importing filters using the import template on the site.

However, if I have a filter with a field with no selections, the import doesn't work for that field. I wasn't able to find how to override values when using the filter import.

For example, for the below filter we need the following filter settings but when I write it as below in the template file and import, the value with overridden values does not show.

These are the values with their selected criteria:

%Data_Level = 2
_DisplayOnly = override values
_OQRIncentive = override values

The way I have it written in the template:

Under "values" column = [_DisplayOnly], [_OQRIncentive]
Under "numeric values column" = %Data_Level={"2"}

I know I have it written incorrectly under the values column but I'm not sure what the correct way to write it is

Thank you!

Re: NP19 Importing Filters with Overridden Values

Lech_Miszkiewicz — Fri, 03 Jul 2020 00:41:55 GMT

Hi @Labiqa

very good point. I went through all my resources and I could not find working solution. We will need to qwait for qlik guys to come back to us i guess.

I tried all the "old" tags from this document for NPrinting 16 hoping that one of them could work. https://community.qlik.com/t5/Qlik-NPrinting-Documents/Advanced-Filters-Syntax-on-Recipients-Import/ta-p/1484923

I also tried to use <override>,<overrideValues>,<override Values>,<Values> tags and none of them seem to work.

Those tags are not really documented.

@Andrew_Kruger @Ruggero_Piccoli

is override value supported in excel import at all?
if they are how can we enforce it - sample files don't provide this information and I was unable to find any documentation?
documentation of existing supporting tags should be included in help document - currently it is not.

thanks

Lech

Re: NP19 Importing Filters with Overridden Values

Ruggero_Piccoli — Fri, 03 Jul 2020 13:37:15 GMT

Hi ,

About https://community.qlik.com/t5/Qlik-NPrinting-Documents/Advanced-Filters-Syntax-on-Recipients-Import/ta-p/1484923 only the documented tags were supported in QlikView NPrinting 16. The supported tags <drop,unlock,lock,verify,excluded,clearselections> were the filter options that were visible in the GUI when you created a filter manually. That behaviour is different in Qlik NPrinting 17+. For example, drop is no more needed because Qlik NPrinting 17+ doesn't have the reload task, in QlikView NPrinting 16 it was possible to run a task that reloaded the local .QVW data. So, this is a case where QlikView NPrinting 16 differs from Qlik NPrinting 17+ and the old documentation is not useful.

What I had understood is that you want to flag the "Override values" checkbox, that is in the fields part of the filters GUI, while importing filters via Excel file, correct? We checked and this is a gap between the GUI and the features of the Excel file to import user because there is not a flag <override> or similar. That confirms the results of @Lech_Miszkiewicz 's tests. In this case I would to ask you to open a support ticket with a link to this conversation.

In the user import task there is also the "Update filters if modified" flag to upgrade all imported filters https://help.qlik.com/en-US/nprinting/June2020/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm#anchor-1

Best Regards,

Ruggero

Re: NP19 Importing Filters with Overridden Values

Lech_Miszkiewicz — Fri, 03 Jul 2020 22:59:54 GMT

Hi @Ruggero_Piccoli

yes I am aware that docmentation was in regards to NPrinting 16.

You have correctly identified the issue and I will open support ticket today.. I will comment here once this is done so you know the support case number. Thanks

Lech

Re: NP19 Importing Filters with Overridden Values

Lech_Miszkiewicz — Sat, 04 Jul 2020 00:46:48 GMT

Hi @Ruggero_Piccoli

I have created a case ticket:

02018963 - NPRINTING USER IMPORT FROM EXCEL LACKING POSSIBILITY TO TURN ON "OVERRIDE" FLAG ON FILTER

regards

Lech

Re: NP19 Importing Filters with Overridden Values

Ruggero_Piccoli — Mon, 06 Jul 2020 06:48:11 GMT

Hi @Lech_Miszkiewicz ,

Thanks a lot for the ticket!

Best Regards,

Ruggero

Re: NP19 Importing Filters with Overridden Values

Labiqa — Mon, 06 Jul 2020 13:17:07 GMT

Hi @Lech_Miszkiewicz and @Ruggero_Piccoli

Thank you both for all of your help!

-Labiqa

Re: NP19 Importing Filters with Overridden Values

pthai — Mon, 18 Sep 2023 02:49:00 GMT

Hi All,

Is there any solution for this until now? Can you pls share it!

Thank a lot.

Re: NP19 Importing Filters with Overridden Values

Lech_Miszkiewicz — Mon, 18 Sep 2023 03:44:46 GMT

Of course there is @pthai - just bookmark https://help.qlik.com and ALWAYS check it for up to date info.

this particular question s described here: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm#anchor-2

Re: NP19 Importing Filters with Overridden Values

pthai — Mon, 18 Sep 2023 05:38:08 GMT

Hi Lech,

The <override> tag is not working.

Only <excluded> seems to work

Re: NP19 Importing Filters with Overridden Values

Lech_Miszkiewicz — Mon, 18 Sep 2023 06:01:35 GMT

Hi @pthai

This is version specific thing - you have not specified what version you are using and if it is not working for you maybe you are using too old version which did not have that functionality?

Help page provides information based on the version you choose there so once you pick the version you are using you would see if that feature is supported or not.

There is no rocket science there - this feature was introduced some time ago and if you want to use it you need to be on version which supports it. If you are on the version which help site says it supports it and it is still not working for you then open Qlik support ticket.

cheers

Re: NP19 Importing Filters with Overridden Values

pthai — Mon, 18 Sep 2023 06:02:37 GMT

Hi Lech,

Im using this version.

Qlik NPrinting June 2020 SR1

Re: NP19 Importing Filters with Overridden Values

Lech_Miszkiewicz — Mon, 18 Sep 2023 06:05:26 GMT

Written black on white - this feature is not there on that version - simple as that: https://help.qlik.com/en-US/nprinting/June2020/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm

1. upgrade to supported version

2. and upgrade will enable this feature.

Re: NP19 Importing Filters with Overridden Values

pthai — Mon, 18 Sep 2023 06:10:20 GMT

Thank a lot!

I got it.