Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
dwforest
Specialist II
Specialist II

Filtering a Detail Report

I have a report with a detail band based on the month that contains the last 12 months of data.

A graph outside the band correctly shows the trend of data.

I would like to filter the detail band so that it shows only the last month's detail.

I have a field MontYearNumeric which represents the numeric value of the first day of the month (Have all kinds of issues with Sense appropriately determining a date vs string - the dual mess never works, anyway..)

I created a calculated field IsLastMonth = MonthYearNumeric = Max(MonthYearNumeric) within the context of the band.

If i add both fields to  the report, I correctly see the value and the last value has Yes for IsLastMonth.

When I add this add a Filter String to the Detail Report (IsLastMonth = Yes), when I preview the report an error is displayed:

The preview request failed with the message: Object reference not set to an instance of an object.

The only way the filter "works" is if I hard code the number, e.g. MonthYearNumeric = 42917.

Any ideas?

7 Replies
Not applicable

something like :

month(now())-1

should work - make the filter based on a formula not a value

dwforest
Specialist II
Specialist II
Author

I am referring to the filter in the NPrinting Designer not the Filters set the in Web Portal and I don't want the entire report to filter just the detail section.

This filter is accessed in Data Section of the properties window.

On a related note, using the Web Portal Filters never works with the  "Evaluate value", it always generates an error:

The preview request failed with the message: Wrong content node response type.

NPriting Version June 2017

Qlik Sense Version 3.2 SR3

Is this something that just doesn't work with Qlik Sense?

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

I you are trying to apply filter on Level using QlikSense connection - this will not work as this functionality is not supported in June version and will be in September version:Download the Technical Preview

Object filters for Qlik Sense charts Jira issue ID: OP-5385 You can add object level filters also to Qlik Sense charts. Previous you could only add filters to QlikView charts. You can still add only one filter for each chart.


As a temporary workaround i would create another object in qliksense application which would contain your filter in set analysis expression. Then i would use this object in a band report. In other words i would try to create as much logic as possible in Qlik App and only apply necessary filters on task or report when usin qliksense.

cheers

Lech

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

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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
dwforest
Specialist II
Specialist II
Author

So as I feared, I will have to create unique variables to "filter" the values.

It would be EXTREMELY helpful if Qlik labeled the features, explicitly and clearly, that won't work with QlikSense, which at this point seems more don't than do.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Mate - first page of help document:

https://help.qlik.com/en-US/nprinting/June2017/Content/Introduction/Introduction.htm

Product CapabilityQlik NPrinting16Qlik NPrinting 17 and newer
Localization

Yes

Yes
Verbose logs

Yes

Yes
Microsoft Office reporting

Yes

Yes
Pixel perfect and web reportingYesYes
Centralized distributionYesYes
On-demand reportingYesYes
APIs Yes
Web based architecture Yes
Online subscription hub Yes
Multi-document reportsYesYes
Enterprise scalability Yes
Roles based security Yes
Section access Yes
Reports with read and write passwordYes
Pretty good privacy (PGP) encryptionYes
Send to printerYes
Print as PDFYes
Multi-developer environment Yes
Recipient imports from ExcelYesYes
Recipient import wizardYes
Conditional reportingYesYes
Dynamic Report NamingYesYes
FTP SupportYes
Cycling reports (creates files for every value of dimensions)Yes
HTML embedded reportsYes
Clone reportsYes
Variables in email messagesYesYes
Cycled pages in multiple slidesYesYes
Variable filterYes
Bookmark filterYes
Object filtersYesOnly with QlikViewobjects
Group filtersYes
Page and level filtersYes
Clear all selectionsYes
Select excludedYes
Linked fieldsYes
Load templateYes

Yes

Test taskYes

Yes

Task failure notificationsYes

Yes

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
dwforest
Specialist II
Specialist II
Author

This is a comparison on v16 vs v17 not QlikView vs  QlikSense

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi, Yes i agree that i would be nice to have a NPrinting feature comp table for QlikSense & QlikView. I was just pointing to feature that you were looking for and this tables states it.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.