topic Re: Filter a Report by Even\Non-even Months. in Qlik NPrinting

Filter a Report by Even\Non-even Months.

sogloqlik — Thu, 28 Mar 2019 14:46:34 GMT

Hi.

Our NPrinting sends a daily sales report of the current month.
Now there is a new demand: If the current month is a Non-Even one (Jan., March etc.) then the time filter should be current month. If the current month is an Even one (Feb., April ect.) then the Time filter should be current month + previous month.
How can I achieve it?

(We are using NP November 2018 and QS November 2018)

Thx.

Motty

Re: Filter a Report by Even\Non-even Months.

dplr-rn — Thu, 28 Mar 2019 16:46:16 GMT

Not an expert in nprinting by any means.
but why dont you handle this in qlik sense side with set analysis.
e.g. your measure is Sum({<$(vSetVariable)>}
you make the set variable appropriately according to your conditions

Re: Filter a Report by Even\Non-even Months.

Lech_Miszkiewicz — Fri, 29 Mar 2019 00:48:52 GMT

Hi,

This is quite easy wit evaluate formula filter. The only thing to remember is to make sure that filters do not contract each other.

In my QlikSense/QlikView scripts i usually create [Cal Month] Field which shows month & year (like Jan-19,Feb19 etc..)

I usually create this field by using formula in script: Date(MonthStart(MyDateField,'MMM-YY'))

With this as a background now i go to NPrinting and use following setup (see screenshot).

I have tested it and it works.

regards

Lech