Conditions and Filters

[NW1965]

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,

[Lech_Miszkiewicz · Accepted solution]

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  this:

https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ReportsDevelopment/Static-dynam...

cheers

Lech

[NW1965]

Thanks Lech, much appreciated.

[Lech_Miszkiewicz]

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

[NW1965]

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.