topic Re: FILTER CURRENT MONTH in Qlik NPrinting

FILTER CURRENT MONTH

qlikuser22 — Mon, 03 May 2021 10:45:14 GMT

I want to filter current month.

I am using N printing PPT with object filters.

Image-> Add Objects -> obj1234

I have created a filter with advanced search : ([Date] >= MonthStart(Today()))

I also tried advanced search: ([Date] >= MonthStart(Today())) * ([Date] <= (Today()))

But without filter being applied, I can see the output. If I apply the object filter, it says invalid selection.

Please help.

Re: FILTER CURRENT MONTH

Lech_Miszkiewicz — Mon, 03 May 2021 12:14:31 GMT

This was discussed so many times on community, so please spend time searching community before posting questions which were already discussed. Thanks!

How is [Date] field created in Qlik data load? Is it date or timestamp or maybe is stored as Text?

For Advanced search filter apply advanced search directly in Qlik filter pane with [Date] field to check if it works.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/filter-of-a-range-of-date/td-p/1799902

I strongly advice you to read carefuly those topics about Dates and pitfalls. Make sure you understand what kind of datatype your field is using!!

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

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

Re: FILTER CURRENT MONTH

Lech_Miszkiewicz — Mon, 03 May 2021 12:16:27 GMT

Re: FILTER CURRENT MONTH

Ruggero_Piccoli — Tue, 04 May 2021 07:06:49 GMT

Hi,

"invalid selection" means that the filter is returning an empty dataset. As I previously suggested to you, before applying filters in Qlik NPrinting test them on the source Qlik Sense app to be sure that you obtain valid datasets.

Apply to the Qlik Sense app ALL the same filters you applied in Qlik NPrinting and, if needed, correct them in Qlik Sense. Only after having the correct filtered dataset copy the filters in Qlik NPrinting.

Best Regards,

Ruggero

Re: FILTER CURRENT MONTH

qlikuser22 — Tue, 04 May 2021 07:12:30 GMT

Thanks for your support. I read the article Dates and Pitfalls and I fixed the issue.

Re: FILTER CURRENT MONTH

Lech_Miszkiewicz — Tue, 04 May 2021 08:33:47 GMT

Again - purpose of community is to help others. Can you share what was the issue in your case? What did you change in your example? What you did not consider but should have?

Answering those questions will help others who search community for help,

cheers and thanks!

Re: FILTER CURRENT MONTH

qlikuser22 — Tue, 04 May 2021 08:54:08 GMT

Sure. I used my advanced filter directly in Nprinintg. I haven't tried in Qliksense App. But when I tried to run the expression in Qliksense app, i had issues with the dataset, when I modified the app and executed the same in Nprinting, it worked well.

Re: FILTER CURRENT MONTH

Lech_Miszkiewicz — Tue, 04 May 2021 08:57:42 GMT

Ok - thank you!