topic Re: Filtering a Detail Report in Qlik NPrinting

Filtering a Detail Report

dwforest — Wed, 09 Aug 2017 18:41:24 GMT

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?

Re: Filtering a Detail Report

Wed, 09 Aug 2017 18:44:50 GMT

something like :

month(now())-1

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

Re: Filtering a Detail Report

dwforest — Wed, 09 Aug 2017 19:33:41 GMT

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?

Re: Filtering a Detail Report

Lech_Miszkiewicz — Thu, 10 Aug 2017 00:23:08 GMT

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.

Re: Filtering a Detail Report

dwforest — Thu, 10 Aug 2017 00:29:36 GMT

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.

Re: Filtering a Detail Report

Lech_Miszkiewicz — Thu, 10 Aug 2017 00:56:00 GMT

Mate - first page of help document:

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

Product Capability	Qlik NPrinting16	Qlik NPrinting 17 and newer
Localization	Yes	Yes
Verbose logs	Yes	Yes
Microsoft Office reporting	Yes	Yes
Pixel perfect and web reporting	Yes	Yes
Centralized distribution	Yes	Yes
On-demand reporting	Yes	Yes
APIs		Yes
Web based architecture		Yes
Online subscription hub		Yes
Multi-document reports	Yes	Yes
Enterprise scalability		Yes
Roles based security		Yes
Section access		Yes
Reports with read and write password	Yes
Pretty good privacy (PGP) encryption	Yes
Send to printer	Yes
Print as PDF	Yes
Multi-developer environment		Yes
Recipient imports from Excel	Yes	Yes
Recipient import wizard	Yes
Conditional reporting	Yes	Yes
Dynamic Report Naming	Yes	Yes
FTP Support	Yes
Cycling reports (creates files for every value of dimensions)	Yes
HTML embedded reports	Yes
Clone reports	Yes
Variables in email messages	Yes	Yes
Cycled pages in multiple slides	Yes	Yes
Variable filter	Yes
Bookmark filter	Yes
Object filters	Yes	Only with QlikViewobjects
Group filters	Yes
Page and level filters	Yes
Clear all selections	Yes
Select excluded	Yes
Linked fields	Yes
Load template	Yes	Yes
Test task	Yes	Yes
Task failure notifications	Yes	Yes

Re: Filtering a Detail Report

dwforest — Thu, 10 Aug 2017 16:03:12 GMT

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

Re: Filtering a Detail Report

Lech_Miszkiewicz — Fri, 11 Aug 2017 00:31:12 GMT

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