Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
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
Daniel_Jenkins
Specialist III
Specialist III

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
everest226
Creator III
Creator III
Author

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

Year(now())-6

Daniel_Jenkins
Specialist III
Specialist III

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.

everest226
Creator III
Creator III
Author

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

Daniel_Jenkins
Specialist III
Specialist III

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

- Daniel.

everest226
Creator III
Creator III
Author

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

Daniel_Jenkins
Specialist III
Specialist III

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.

everest226
Creator III
Creator III
Author

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

Daniel_Jenkins
Specialist III
Specialist III

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.

everest226
Creator III
Creator III
Author

sure i will create another thread, thanks Daniel