topic Re: Date Filter Not Working In N Printing Report in Qlik NPrinting

Date Filter Not Working In N Printing Report

gopipnr — Fri, 15 Nov 2024 21:18:16 GMT

I am trying to filter the date, but I am unable to do it. The same logic is working in the other report. Any suggestions are appreciated. thanks in Advance

Re: Date Filter Not Working In N Printing Report

ajaykakkar93 — Tue, 31 Oct 2023 04:40:44 GMT

Hi,

I suggest you to create a copy of the same date column & convert it into the number format & then use the filter it will work

Re: Date Filter Not Working In N Printing Report

Lech_Miszkiewicz — Tue, 31 Oct 2023 09:51:07 GMT

Hi @gopipnr

i on the other hand suggest to learn and educate yourself about data types in Qlik Sense and how they affect Nprinting filters.
I have described all issues in below topics:

you dont need to create new columns but you need to understand your data, be in control of its type and then apply suitable filter.

Lastly search community for similar topics instead of creating and repeating the same topic over again-here is example from last week: https://community.qlik.com/t5/Qlik-NPrinting/Filter-specific-date-dd-mm-rrrr-eg-22-10-2023/td-p/2130751

Re: Date Filter Not Working In N Printing Report

gopipnr — Mon, 20 Nov 2023 10:26:35 GMT

Thanks @ajaykakkar93 , But I have figured it out I have used

[Received_Date]>=date('10/01/2023') and [Received_Date]<=date('10/25/2023')

expression to solve the issues.