Apply greater then or less then filter in NPrinting 16

[#1]

Hi Guys,

I want to apply a dynamic Date Range filter in NPrinting.

For this..

• I have created two variables in QlikView.
• vMinDate & vMaxDate
• The values of this two variables are set based on the logic.

How can I apply this variables as filter in NPrinting to get Order Date >= vMinDate & <=vMaxDate

Thanks

[Daniel_Jenkins]

Hi Lokesh,

Take a look at my example project here: filter in Nprinting

HTH - Daniel

[#3]

Thanks Daniel,

I will let you know if it works or not.

Thanks

[#4]

Hi Daniel,

I just read the link you mentioned and tried to implement that but it is not working

I have created a test QVW and NSQ and named the variables same as the variables in your sample ZIP file.

vStartDate & vEndDate but my Date Field name is [Order Date]

Now.. When I run your NSQ file then filter works perfectly as expected but when I run my NSQ file then it does not work.

Below is the filter you have applied in your attached ZIP file.

And here is the filter I am using in my test file.

It tells me this..

Am I missing anything?

[Daniel_Jenkins]

Hi Lokesh,

You get that warning if Verify filter is enabled and your filter causes an empty result set to be returned. You have filtered for <=StartDate and >= EndDate - perhaps that has something to do with it? If you can post your (simplified) project here I'll take a look.

HTH - Daniel.

[#6]

I am just attaching a sample QVW and NSQ in 5 minutes

[#7]

Here it is.

Thanks

[Daniel_Jenkins]

Your variables vStartDate & vEndDate have no values. I would work on that first before adding them to a filter.

best,

Daniel.

[#9]

Hi Danielle, If you will select a customer name where Billing Cycle is Weekly then you will get those values

[#10]

So 1 Customer can have more than 1 Department

And Each department have different billing cycle.

This billing cycles can be Weekly, Monthly or Twice weekly.

The report has 2 Cycles (customer and department)

So when the customer has billing date as Date(today()) then it will automatically add the values in variables.