topic Re: Nprinting Filter by the previous week in Qlik NPrinting

Nprinting Filter by the previous week

djbloiss — Mon, 22 Jan 2018 16:14:05 GMT

I have a field called [FISC Week #] and I need to filter my report by the previous week. I am quite new.

I have tried numerous ways? and it will not give me a value.

=FirstSortedValue([Transaction Date] = Date(Now()) - 7, [FISC Week Ending Date])

=FirstSortedValue(Max([Transaction Date])-7, [FISC Week Ending Date])

=Week(Today))-1

Re: Nprinting Filter by the previous week

Daniel_Jenkins — Tue, 23 Jan 2018 02:17:59 GMT

Hi Daniel,

QlikView or Qlik Sense Connection? And what version of NPrinting?

- Daniel.

Re: Nprinting Filter by the previous week

Chanty4u — Tue, 23 Jan 2018 06:44:36 GMT

Hi,

you can create a variable in qlik for previous week and you can add the variable in conditions in nprinting

or else you can create a previous week as column in the raw data and add that field as filter in nprinting.

Re: Nprinting Filter by the previous week

Ruggero_Piccoli — Tue, 23 Jan 2018 08:30:48 GMT

Hi,

I would to suggest you to read the page about Filters in the official Qlik NPrinting help site Filters ‒ Qlik NPrinting. This will give you an idea about how you can use filters and what you can get.

You are quite new so I also would to suggest to follow the getting started guide step by step Getting started ‒ Qlik NPrinting‌

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Nprinting Filter by the previous week

djbloiss — Tue, 23 Jan 2018 15:59:31 GMT

Qlikview and Nprinting version 16.

I am trying =Week(Today))-1

and I have tried:

=FirstSortedValue([Transaction Date] = Date(Now()), [FISC Week Ending Date])

=FirstSortedValue(Max([Transaction Date])-7, [FISC Week Ending Date])

Re: Nprinting Filter by the previous week

djbloiss — Tue, 23 Jan 2018 16:00:19 GMT

how would I create a variable in Qlikview? I am brand new to qlik and training myself.

Re: Nprinting Filter by the previous week

snehamahaveer — Tue, 23 Jan 2018 16:08:14 GMT

Hi Daniel,

Do the following as a new filter and use the filter in your report/task.

Select the Field as 'Week'

Under Value place this formula =Week(Today())-1

Tick IsNumeric and Evaluate - otherwise it Nprinting would not calculate the value to week as 3 (for previous week)

You can also tick verify filter to check the formula works before running the report.

Regards

Re: Nprinting Filter by the previous week

Daniel_Jenkins — Tue, 23 Jan 2018 22:59:02 GMT

Hi Daniel,

Sneha's solution will work.

Example: If you have this

Filter:

Result:

See sample project attached.

HTH - Daniel.

Re: Nprinting Filter by the previous week

Ruggero_Piccoli — Wed, 24 Jan 2018 09:07:38 GMT

Refer to the official QlikView help site New Variable ‒ QlikView

Best Regards,

Ruggero

---------------------------------------------