Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Mayhan
Partner
Partner

Nprinting And filter

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?

ResultResult2 Filters2 Filters

2 Solutions

Accepted Solutions
Lech_Miszkiewicz

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-i...

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Lech_Miszkiewicz

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. 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

6 Replies
Lech_Miszkiewicz

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-i...

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Mayhan
Partner
Partner
Author

Hi Lech,

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

Cheers,

 

Lech_Miszkiewicz

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. 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Lech_Miszkiewicz

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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Mayhan
Partner
Partner
Author

Hi Lech,

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

Cheers,

Lech_Miszkiewicz

I told you 🙂
cheers
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.