Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Daniel,
Sneha's solution will work.
Example: If you have this
Filter:
Result:
See sample project attached.
HTH - Daniel.
Hi Daniel,
QlikView or Qlik Sense Connection? And what version of NPrinting?
- Daniel.
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.
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.
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])
how would I create a variable in Qlikview? I am brand new to qlik and training myself.
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
Hi Daniel,
Sneha's solution will work.
Example: If you have this
Filter:
Result:
See sample project attached.
HTH - Daniel.
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.