topic Filter By Previous Day in Qlik NPrinting

Filter By Previous Day

Pomna — Wed, 23 Sep 2020 02:36:25 GMT

I need help creating a filter in Nprinting to get only values for the previous day. Below is what I have got but it does not give me the expected answer. Your suggestions will be appreciated. Thanks

Re: Filter By Previous Day

robert_mika — Wed, 23 Sep 2020 03:14:57 GMT

Change Advance Search to Evaluate Value and in the field enter

=Today()-1

Re: Filter By Previous Day

Lech_Miszkiewicz — Wed, 23 Sep 2020 03:49:49 GMT

Hi @Pomna

@robert_mika answer will work if your date field which I assume is "CusSat Created Date" is loaded as a date without timestamp. On Qlik script side it should be loaded with statement similar to following:

Load

....

Date(Floor(somedate)) as [CusSat Created Date]

....

The above scenario will filter down data on [CusSat Created Date] only to yesterdays records.

I also looked at your screenshot and I am trying to understand what you have tried to do in there. You have used [Date] field and you wanted to filter [CusSat Created Date] by using association to [Date] field which you wanted to filter to records greater or equal than yesterdays date.

Now the question is:

do you have [Date] field in your data model and did you want to use it to apply filters on [CusSat Created Date]?
- If you do - then how those 2 fields are associated in your data model as results will depend on association

cheers

Lech

Re: Filter By Previous Day

Pomna — Wed, 23 Sep 2020 15:01:11 GMT

I added the following to my load script

Date(Floor([CusSat Date])) as [CusSat Created Date] to my load script

and Evaluete Value =Today()-1

It worked. But when I want to see two previous days

Today()-2

or seven previous days

Today()-7

I get an error message. Is there a reason for that? Thanks

Re: Filter By Previous Day

Ruggero_Piccoli — Wed, 23 Sep 2020 15:04:17 GMT

Hi,

Please specify the text of the error message.

Best Regards,

Ruggero

Re: Filter By Previous Day

Pomna — Wed, 23 Sep 2020 15:13:25 GMT

Below is the error message I get

Re: Filter By Previous Day

Lech_Miszkiewicz — Wed, 23 Sep 2020 22:47:43 GMT

There are 3 possible separate issues with this:

first issue is more of a conceptual one. If you want to see last 7 days you need to create in your filters 7 rows like below, as effectively you are talking not about one but multiple days:
- Evaluete Value =Floor(Today()-1)
- Evaluete Value =Floor(Today()-2)
- Evaluete Value =Floor(Today()-3)
- ...
- Evaluete Value =Floor(Today()-7)
Second issue is related to the error you attached. For some reason this filter cannot be applied and there can be multiple reasons. First one which came to my mind was that you have "Always one selected value" set on this field in QlikView (and/or triggers) - both are not supported and need to be removed from your document if they exist. The other option would be to apply Floor() function on calculation - see in the example above the red highlighted part. I know that in this case it shouldn't matter but I want to make sure that the actual value of the filter is not an issue here..
Do you apply any other filters (on task, report, user level) which would exclude data for Today()-2 etc days?

You may also provide a screenshot of your filter in NPrinting for a reference here.

Re: Filter By Previous Day

Pomna — Fri, 25 Sep 2020 22:42:04 GMT

Thank you for all your help. When I do just the date filter with just one field or only the assigned team filter with only one field it runs without issue. But when I create a second field (see screen shots below) that is when I get issues.

Re: Filter By Previous Day

Lech_Miszkiewicz — Sat, 26 Sep 2020 02:26:14 GMT

ok then it looks like combinations of values you are trying to apply is not possible in your data model or your filter for Assigned team is created wrong although based on what you say it is not as it works on its own..

So just to confirm my first guess I suggest you go to Qlik Sense app an try applying this selection there - is it possible?

Re: Filter By Previous Day

Pomna — Mon, 28 Sep 2020 15:27:05 GMT

The selection works in Qlik Sense. Assigned team is filtered by date. Please see screen shot below

Re: Filter By Previous Day

Lech_Miszkiewicz — Tue, 29 Sep 2020 01:29:55 GMT

In filter pane it looks like your date is not a straight field but expression. Can you try to use a naked field you mentioned you have created instead?

I just want to confirm the obvious:

there is no "Always one selected values"?
there is no "trigger"s or "default bookmarks" in this app?

Re: Filter By Previous Day

Lech_Miszkiewicz — Tue, 29 Sep 2020 01:33:01 GMT

also - do you intersect other filters which exclude themselves? User filters maybe created in this connection?

Re: Filter By Previous Day

Pomna — Wed, 30 Sep 2020 16:34:12 GMT

Thank you so much for all the help. I realized that the report throws an error when no report is generated or when there is no data to show. So the solutions above work. Thank you