Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

djbloiss
New Contributor III

Nprinting Filter by the previous week

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

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Nprinting Filter by the previous week

Hi Daniel,

Sneha's solution will work.

Example: If you have this

Filter:

Result:

See sample project attached.

HTH - Daniel.

8 Replies
Employee
Employee

Re: Nprinting Filter by the previous week

Hi Daniel,

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

- Daniel.

sureshqv
Esteemed Contributor III

Re: Nprinting Filter by the previous week

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.

Employee
Employee

Re: Nprinting Filter by the previous week

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
djbloiss
New Contributor III

Re: Nprinting Filter by the previous week

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
New Contributor III

Re: Nprinting Filter by the previous week

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

snehamahaveer
New Contributor III

Re: Nprinting Filter by the previous week

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

Employee
Employee

Re: Nprinting Filter by the previous week

Hi Daniel,

Sneha's solution will work.

Example: If you have this

Filter:

Result:

See sample project attached.

HTH - Daniel.

Employee
Employee

Re: Nprinting Filter by the previous week

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Community Browser