Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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-dynam...
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
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-dynam...
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
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