Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

NPrinting and Custom Date Filter

I am using NPrinting and have a date field I use in the QVW called FISCAL_MONTH_YEAR which is formatted like 03/2015. I need to get my NPrinting report running for the current month but using =month(now())  & =year(now()) don't achieve what I need. How can I get the report to run for the current month/year?

TIA

1 Solution

Accepted Solutions
Andrea_Bertazzo
Support
Support

Hi Cassandra,

You can use this formula:

=date(now(),'MM/YYYY')

This returns the today month and Year in the format you require.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂

View solution in original post

1 Reply
Andrea_Bertazzo
Support
Support

Hi Cassandra,

You can use this formula:

=date(now(),'MM/YYYY')

This returns the today month and Year in the format you require.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂