topic Nprinting condition or filter in Qlik NPrinting

Nprinting condition or filter

everest226 — Thu, 01 Dec 2016 18:07:00 GMT

I have to generate report from tab which will get the whole tab object, i have only one field based filter to get data for one country. country is in listbox.. now question is i have year list box and months listbox but i only want data from july to till this date .report runs every months. what is best practice and how .

Re: Nprinting condition or filter

everest226 — Tue, 06 Dec 2016 00:28:48 GMT

i did some changes in filter field and it work, might be helpful

Year(now())-6

Re: Nprinting condition or filter

Daniel_Jenkins — Tue, 06 Dec 2016 00:46:49 GMT

Hi Ujjwal,

I can't see how Year(now())-6 - which results in 2010 (2016 - 6 = 2010) - will filter your data for "July till this date". I can't understand what you want exactly. For instance, what would you want to be returned in February 2017?

- Daniel.

Re: Nprinting condition or filter

everest226 — Tue, 06 Dec 2016 00:53:27 GMT

i mean months(now())-6

but you are right ,

what i am trying to get is from july 2016 to current months so in 2017 feb i want data from 2016 july to feb 2017

Re: Nprinting condition or filter

Daniel_Jenkins — Tue, 06 Dec 2016 00:57:05 GMT

What version of NPrinting are you using? Can you paste a screenshot of your filter definition?

- Daniel.

Re: Nprinting condition or filter

everest226 — Tue, 06 Dec 2016 01:01:36 GMT

Nprinting16. i am out of office. wish i could attach screen shot

Re: Nprinting condition or filter

Daniel_Jenkins — Tue, 06 Dec 2016 01:29:49 GMT

Since you are using version 16, I suggest you create a new field using a valid existing date field (I'm using OrderDate) in the load script like so:

Year(OrderDate)& num(Month(OrderDate),'00') as YearMonthNum

and use that in a field filter:

You can make it more dynamic by using functions like Year() & Month() to build whatever value you want.

HTH - Daniel.

Re: Nprinting condition or filter

everest226 — Wed, 07 Dec 2016 00:26:10 GMT

Thanks , just a question how do i fit sheet in world report,somehow in report it dose not fit

Re: Nprinting condition or filter

Daniel_Jenkins — Wed, 07 Dec 2016 00:30:56 GMT

Hi Ujjwal,

Please create a new thread for unrelated queries so others will benefit when searching these forums.

For your particular issue I suggest that you attach a simple sample QVW & screenshots of the issue in the new thread.

Best,

Daniel.

Re: Nprinting condition or filter

everest226 — Wed, 07 Dec 2016 01:04:39 GMT

sure i will create another thread, thanks Daniel