topic Nprinting And filter in Qlik NPrinting

Nprinting And filter

Mayhan — Wed, 16 Jan 2019 09:46:48 GMT

Hi,

I made a Nprinting (Nprinting 18) report. Where I have created and used 2 separate filters. 1 filter where the status must be "open" and the other filter with a date "1900-01-01".

The intention is that both filters are used, so an AND function (filter 1 AND filter 2). After I have run the report it seems like the filters work separately. I get all data from status "Open" and the date "1900-01-01". While the intention is that the status should be "Open" and "1900-01-01" and that I want to see this.

I have already tried to prioritize the order of the filters. In addition, in the filter settings check mark of Override Values on and unchecked. Does anybody know how to fix this?

Result2 Filters

Re: Nprinting And filter

Lech_Miszkiewicz — Wed, 16 Jan 2019 11:08:32 GMT

Hi,

the your filters are built is right and they should work as "AND" condition

What i suspect is wrong with your filters is data type which means that your filters are not applied.

have a read here to understand more:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/what-is-syntax-for-nprinting-filter-value-in-list/td-p/1411918

and here

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-Filter-Not-Filtering/td-p/92330

and here

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Dynamic-Filter-Nprinting-17/m-p/1336469

Re: Nprinting And filter

Mayhan — Wed, 16 Jan 2019 10:56:16 GMT

Hi Lech,

Thanks for the links, have indeed read the links only I see no solution to my problem.

Cheers,

Re: Nprinting And filter

Lech_Miszkiewicz — Wed, 16 Jan 2019 11:07:41 GMT

Hi,

In those links i explain how datatype matters in NPrinting filtering. As your date field can actualy be a numeric,date type it can be shown on front-end as 1900-01-01 which for nprinitng filter means numeric value = 1

Note that in the place where you put value = 1900-01-01 you could choose from dropdown "numeric value" = 1

but...

to establish what datatype is used in your date field you need to check it in for example table viewer/data model viewer in Qlik directly.

Re: Nprinting And filter

Lech_Miszkiewicz — Wed, 16 Jan 2019 11:10:59 GMT

one more note,

check https://help.qlik.com for instructions on how to use "Override..." check box in your filters. As you are using it if the values between your filters are excluding each other the second filter will be applied.

Re: Nprinting And filter

Mayhan — Wed, 16 Jan 2019 12:51:34 GMT

Hi Lech,

Thanks it works now, the value must be Numeric value is.

Cheers,

Re: Nprinting And filter

Lech_Miszkiewicz — Wed, 16 Jan 2019 12:52:23 GMT

I told you 🙂
cheers