week name filter - Qlik Community

ilanbaruch · ‎2020-09-10

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

Jacob_Poole · ‎2020-09-10

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

Ruggero_Piccoli · ‎2020-09-11

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

-

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.