Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Nprinting condition or filter

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 .

1 Solution

Accepted Solutions
Support
Support

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.

View solution in original post

9 Replies
Creator III
Creator III

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

Year(now())-6

Support
Support

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.

Creator III
Creator III

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

Support
Support

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

- Daniel.

Creator III
Creator III

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

Support
Support

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.

View solution in original post

Creator III
Creator III

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

Support
Support

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.

Creator III
Creator III

sure i will create another thread, thanks Daniel