Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
something like :
month(now())-1
should work - make the filter based on a formula not a value
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?
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.
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.
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 |
This is a comparison on v16 vs v17 not QlikView vs QlikSense
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