Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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:
and this:
cheers
Lech
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:
and this:
cheers
Lech
Thanks Lech, much appreciated.
no worries - out of curiosity - was i right with " numerical value..."? Did it work when you change this in your filter?
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.