topic Re: Filter/Field edit on NPrinting in Qlik NPrinting

Filter/Field edit on NPrinting

RentiaC — Mon, 11 Dec 2017 09:03:17 GMT

good day

currently I have an published report that pulls data for the current month.

the filter field being used is =only({=$(=Date((Today() )))}YearMonth)

I'm relatively new to nprinting and sql, how can this formula be changed to get the Prev Months data.

for example it runs now from 1Dec to 31 Dec

but the require 1 Nov to 30Nov

thanks

Chanty4u — Thu, 21 Dec 2017 13:42:20 GMT

create a a max month-1 in the data and you will get the last month data

same use that column in filter then you will get the expected data

pipuindia99 — Tue, 26 Dec 2017 16:35:07 GMT

Hi,

You can add this expression in the filter condition

Month(Today())-1

this will take to prev month data.