topic Re: Conditions and Filters in Qlik NPrinting

Conditions and Filters

NW1965 — Wed, 25 Sep 2019 18:40:54 GMT

Hi Folks

I have some issues trying to get a combination of filters and conditions to work, however, for the purposes of this entry I am just trying to understand filters.

I have a filter applied to my User Account in Nprinting.

I have a report that is executed and that report is executed for me, so the filter I have against my account should be applied.

1. I apply a country filter of Great Britain, that value for Country exists in the data model and the report is properly executed and filtered, and I am delivered a report that contains data for Great Britain.

2. I apply a country filter of Test Country, that value for Country DOES NOT exist in the data model and I get an email that states that the report has an error.

3. I apply a Employee ID filter of 99999, that value does not exist, I get the error message in the email.

4. I apply a employee ID filter of 01643592, this value does exist in the data, it should return a report with 10 entries, it actually returns ALL data.

So, #4 makes no sense to me, does anybody have any idea why this might happen?

Thanks,

Re: Conditions and Filters

Lech_Miszkiewicz — Wed, 24 Apr 2019 12:16:01 GMT

So, Nprinting filters are highly dependent on data type which is used to store field value in Qlik data model. To me it looks like your "#4" example is actually stored as a number and your filter should have "numerical value" = 01643592

see this:

https://nprintingadventures.wordpress.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/

and this:

https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-2

cheers

Lech

Re: Conditions and Filters

NW1965 — Wed, 24 Apr 2019 12:22:12 GMT

Thanks Lech, much appreciated.

Re: Conditions and Filters

Lech_Miszkiewicz — Wed, 24 Apr 2019 12:25:48 GMT

no worries - out of curiosity - was i right with " numerical value..."? Did it work when you change this in your filter?

Re: Conditions and Filters

NW1965 — Thu, 25 Apr 2019 07:43:20 GMT

Hi Lech

Yes, it was as simple as changing the value type to "Numerical Value Is", I actually hadn't even noticed the parameter list 🙂

Thanks again.