Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Filter data by date

I need to create date filter in NPrinting to get only data for the last six months. Below is what I got but its not working. Thanks for your suggestions

Pomna_0-1594334675618.png

 

Labels (2)
1 Reply

Hi @Pomna ,

You are not using correct filter type. In place where you have "value is" there is a dropdown. Use it to toggle it to Advanced Search type.

More on that here:

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

 

Also very important - you are using functions MonthEnd etc.. those functions also return timestamp (instead of date) which is often another common pitfall of wrongly applied filters. More on this here:

https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/

 

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.