topic Re: Nprinting Preview showing 'Invalid Selection' in Qlik NPrinting

Nprinting Preview showing 'Invalid Selection'

myself — Mon, 18 Mar 2024 08:06:27 GMT

Hi,

I have created a filter in nprinting for the field Mastermonthyear of value 'Jan-2024'. If I use this filter for an image object in PPT, the output is showing as invlaid selection. I am surprised because If i apply this selection in the dashboard the data is shown properly for that selection.

Re: Nprinting Preview showing 'Invalid Selection'

Lech_Miszkiewicz — Mon, 18 Mar 2024 09:21:46 GMT

HI @myself

no offense - but I call it "rookie mistake".

You have not done homework and you have not studied how filters have to be built especially focusing on datatypes of field you want to apply filter to.

Please study this: https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-5

This part is critical:

Your Jan-2024 value is likely Date(MonthStart(Date),'MMM-YYYY') field which effectively is date field which requires numeric value filter as highlighted. Obviously I cannot tell you 100% without seeing how the field is created in script and then previewing its data type in data model viewer but from my experience 99.9% of the times it is what i wrote above.

cheers

Re: Nprinting Preview showing 'Invalid Selection'

Lech_Miszkiewicz — Mon, 18 Mar 2024 09:23:41 GMT

I will just add to it:

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

you may read all other filter related topics I wrote on my blog:

https://nprintingadventures.com/category/nprinting/filters/

cheers