topic Re: week name filter in Qlik NPrinting

week name filter

ilanbaruch — Thu, 10 Sep 2020 14:21:07 GMT

hi all,

in my model i have a week number field.

i want to create a NP filter for previous year that will calculate all the weeks until the current.

i.e : for year 2019 the filter will apply on week number 1-36

any ides ?

advanced thanks

Re: week name filter

Jacob_Poole — Thu, 10 Sep 2020 14:36:05 GMT

Can you share an example of how your calendar is structured?
Have you tired creating a filter using multiple fields?
Maybe one on where the week number is <= the week number of today, and the year =Year(Today())-1

Re: week name filter

Ruggero_Piccoli — Fri, 11 Sep 2020 09:16:23 GMT

Hi,

If you are still using QlikView NPrinting 16.7 I strongly suggest you to migrate to a supported version, better latest.

Advanced filters are supported in both, QlikView NPrinting 16 and latest September 2020, so you use it.

Best Regards,

Ruggero