Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to pass date range as filter nprinting feb 19 version

Dear All,

I have a qlikview chart and expression as below

Sum({< TRANSDATE ={'>=$(=Date(vCIAsOnDate))<=$(=Date(vCIAMonthEndDate))'}>} AMOUNT)*-1

I have  a field startcalenderdate  which has date 01/04/2019 then my vCIAsOnDate  is 01/04/2019  and vCIAMonthEndDate is 30/04/2019.

 

How I pass this value as filter in nprinting.

 

3 Replies
Highlighted
Support
Support

Re: How to pass date range as filter nprinting feb 19 version

Hello,

I wanted to respond to your thread.

Have you by chance viewed this older Qlik Community post?

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Date-filters-in-nPrinting-17/td-p/1259003

Can you let me know if this helps, if so please mark this as a Solution.

Regards,

Eva

Highlighted
Support
Support

Re: How to pass date range as filter nprinting feb 19 version

Here is one from Daniel J as well.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/filter-in-Nprinting/td-p/1085385

@lech has a solution too but I can't find it.

Lech? Comments?

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Highlighted
Support
Support

Re: How to pass date range as filter nprinting feb 19 version

Hi @tripatiqv ,

You should consider upgrading to version June 2019. If you do, you can use Advanced search filters. See Example 1 option 3 here: https://community.qlik.com/t5/Qlik-NPrinting-Documents/Examples-of-Advanced-Search-Filters/ta-p/1594...

Other options involve creating flags for all records that fall within that date range (in the load script) and filtering on that flag. 

HTH - Daniel.