Nprinting Filter by the previous week

[djbloiss]

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

[Daniel_Jenkins]

Hi Daniel,

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

- Daniel.

[Chanty4u]

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.

[Ruggero_Piccoli]

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.

[djbloiss]

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])

[djbloiss]

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

[snehamahaveer]

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

[Daniel_Jenkins · Accepted solution]

Hi Daniel,

Sneha's solution will work.

Example: If you have this

Filter:

Result:

See sample project attached.

HTH - Daniel.

[Ruggero_Piccoli]

Refer to the official QlikView help site New Variable ‒ QlikView

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.