Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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