topic Filtering on previous WeekName in Qlik NPrinting

Filtering on previous WeekName

Qlik_ULG — Mon, 23 Sep 2019 18:56:35 GMT

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

Re: Filtering on previous WeekName

Lech_Miszkiewicz — Tue, 08 Jan 2019 22:01:02 GMT

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

Re: Filtering on previous WeekName

Qlik_ULG — Thu, 10 Jan 2019 13:34:56 GMT

Thank you very much, lech.

This is very helpful.