Filtering on previous WeekName

[Qlik_ULG]

Hi,

I'm currently having an issue when trying to apply a filter in nPrinting to return values based on the previous WeekName.

Returning based on the current WeekName works fine, when I use the following syntax =WeekName(Today()) and set it to 'Evaluate Value'.

However, when using =WeekName(Today())-1 to return the data for the previous WeekName, it fails. I'm assuming that this is because it can't evaluate what is strictly not a numeric value.

This syntax did work in the previous version of nPrinting, and I'd prefer not to set the filter in QV itself through set analysis.

The reason I'm using WeekName rather than Week is to avoid any issues at year-end, and having to set and change a Year filter.

Is there different syntax which can be applied to resolve this in the nPrinting WeekName filter?

Any help would be greatly appreciated.

Thanks

[Lech_Miszkiewicz · Accepted solution]

Hi,

The principal you are trying to achieve is identical to this one:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Dynamic-Filter-Nprinting-17/m-p/1336469

Solution:

Check datatypes created in Qlik and make sure you use the same ones in NPrinting

regards

Lech

[Qlik_ULG]

Thank you very much, lech.

This is very helpful.