topic Calculated filter doesn't work in NP 16.5 in Qlik NPrinting

Calculated filter doesn't work in NP 16.5

rviel_dubo — Mon, 07 Nov 2016 17:33:56 GMT

Hi everyone,

I need help understanding why my calculated filter doesn't work.

First filter work great but the "Current Year" just don't seems to work.

I've got no filter on the chart.

But my result shows all years.

Any suggestion woul dhelp.

Thanks in advance

Re: Calculated filter doesn't work in NP 16.5

Daniel_Jenkins — Mon, 07 Nov 2016 20:57:14 GMT

Hi Robert,

Perhaps your filter combination returns no records? Do all the years returned include current year? Check the Verify filter check box on the filter and try again. Take a look at this document to learn about Verify filter and other filter parameters: How to Create Static and Dynamic Filters Based on Fields

HTH - Daniel.

Re: Calculated filter doesn't work in NP 16.5

rviel_dubo — Mon, 07 Nov 2016 21:21:14 GMT

Hi Daniel,

I've checked the "Verify filter" and got this message on preview.

That just prouve that the filter doens't work since I do have records for those specifics filters as shown below.

Robert

Re: Calculated filter doesn't work in NP 16.5

Daniel_Jenkins — Mon, 07 Nov 2016 21:43:49 GMT

Hi Robert,

That is exactly what I expected. Sales_Year = Year(now()) returns no values. Now I would try to figure out why. What happens if you use a hard coded value (2016) instead of Year(Now())? I will also check the load script to see how Sales_Year is defined. If you upload a simple QVW someone can take a look.

HTH - Daniel.

Re: Calculated filter doesn't work in NP 16.5

rviel_dubo — Mon, 07 Nov 2016 22:01:48 GMT

Hi Daniel,

I do get records using 2016 as hard coded filter instead of formula.

Here's a copy of my script for the calendar.

Format number for Sales_Year hasn't been modified

I'll try to make a supset of my application to share with you.

Thanks again for your time

Robert

Re: Calculated filter doesn't work in NP 16.5

Daniel_Jenkins — Mon, 07 Nov 2016 22:21:53 GMT

Hi Robert,

I would create a new field using Year(TempDate) instead of date(Yearstart..etc.) in the load script and use that field in the filter.

HTH - Daniel.

Re: Calculated filter doesn't work in NP 16.5

rviel_dubo — Tue, 08 Nov 2016 13:20:33 GMT

Hi Daniel,

Modified the script and all goes well now.

Thanks a lot