topic Re: previous month data in Qlik NPrinting

previous month data

raadwiptec — Wed, 06 Jan 2016 10:57:49 GMT

hi all,

iam using nprinting to deliver the data . I am trying to apply a filter for one of the columns called transaction date. Basically I only need previous months data .

please suggest

Re: previous month data

prma7799 — Wed, 06 Jan 2016 11:00:51 GMT

You can use filter like

=date(addmonths(max([Date]), -1), 'MMM')

Re: previous month data

prma7799 — Wed, 06 Jan 2016 11:01:38 GMT

Or you can create variable in your qvw file and use it into Nprinting filter.

Re: previous month data

Stephen_Jasionowski — Wed, 06 Jan 2016 15:00:50 GMT

something like month(now()) -1 should also do the trick

Re: previous month data

raadwiptec — Thu, 07 Jan 2016 08:35:56 GMT

it is not getting filtered

Re: previous month data

Daniel_Jenkins — Thu, 07 Jan 2016 08:44:27 GMT

Hi,

Please post a sample QVW and sample Excel file showing what output you want.

- Daniel.

Re: previous month data

raadwiptec — Thu, 07 Jan 2016 08:52:10 GMT

hi Daniel,

Iam using a report with following data

transid ¦ custname ¦ billing date

1 xxx1 12/12/2015

2 xxx2 11/12/2015

3 xxx3 10/12/2015

4 xxx4 09/11/2015

5 xxx5 08/10/2015

My first problem is I have a Year and Month List box. So whenever I open the report fresh. it shows 2016 and chart shows empty as their is no data for 2016. So I want to make it always all data visible

secondly I am calling this report via nprinting. and would like to limit the data only to last month before sending to the user. I tried couple of option with billing date as mont(now() -1 ...et etc but it is not filtering

Re: previous month data

Daniel_Jenkins — Thu, 07 Jan 2016 10:17:10 GMT

Hi,

Regarding showing all values when the QVW opens I believe you need to un-check the Always one selected value check box in the General tab of the list box properties.

I gather that you have a QVW with a list box and chart like this:

...and you want a report filtered only for billing date falling in the last month like this:

I would:

1. Add a calculated field (YearMonthNum) in the load script like this

T1:
LOAD * INLINE [
transid, custname, billing date
1, xxx1, 12/12/2015
2, xxx2, 11/12/2015
3, xxx3, 10/12/2015
4, xxx4, 09/11/2015
5, xxx5, 08/10/2015
];

Transactions:
LOAD *,
Year([billing date]) & num(Month([billing date]),'00') as YearMonthNum
RESIDENT T1;

DROP TABLE T1;

2. In NPrinting use a Field filter defined like this:

I have attached a sample project. Please extract to folder C:\Temp\Community\025 in order to preserve the paths used.

HTH - Daniel.

Re: previous month data

raadwiptec — Mon, 18 Jan 2016 14:53:31 GMT

the above is not giving any results..

Re: previous month data

Daniel_Jenkins — Mon, 18 Jan 2016 15:18:09 GMT

I just checked and it is working fine.

* Did you extract to folder C:\Temp\Community\025?

* Did you check your Default output folder after running the report task?

If it still does not work can you attach the log file (look under File > Options > Log settings to get the location)?

- Daniel.