Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
florian63
Contributor II
Contributor II

Applying a filter to a chart - Tabular report

Hello,

Our company is in the process of moving to Qlik Cloud. We are in the process of migrating Nprinting reports to the cloud, mainly tabular reports, as they are based on Excel models.

On some reports, we are encountering migration problems. For example, we are applying a filter on a line graph for data from a specific week (filter CSL_Last_Week_Actual_Year on graph <wyEBjY>, screenshot below of Nprinting design).

florian63_0-1737102933615.png

When I export this Nprinting template to a tabular report template (with "Export Qlik Cloud reports" on Qlik Nprinting web console), I get an error because this functionality is not available in tabular reports : "Object filters are not supported. The following tags will not be filtered"

florian63_1-1737103931556.png

 

How can I apply a specific filter to a specific graph on Qlik Cloud Reporting? With tabular reports, Pixelperfect, automation, etc...

 

Thanks,

Florian

Qlik NPrinting 

Qlik Cloud 

2 Solutions

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi @florian63 

simple answer is: you cannot.

This is well known and documented gap between NPrinting and Tabular Reporting. 

The workaround could be to use:

  • dedicated chart with set analysis or variable filter
  • dedicated chart with alternate state since tabular reporting supports alternate states.

cheers

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.

View solution in original post

Andrew_Kruger
Employee
Employee

Please see the post here for an example of using Alternate States for the purpose of an object based field reduction.  https://community.qlik.com/t5/Qlik-Reporting-Service/Filtering-an-object-in-a-report-Tabular-and-Pix... 

View solution in original post

5 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi @florian63 

simple answer is: you cannot.

This is well known and documented gap between NPrinting and Tabular Reporting. 

The workaround could be to use:

  • dedicated chart with set analysis or variable filter
  • dedicated chart with alternate state since tabular reporting supports alternate states.

cheers

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.
florian63
Contributor II
Contributor II
Author

@Lech_Miszkiewicz Thank you very much for your fast answer ! I have to admit I didn't know about this gap..

@Andrew_Kruger I heard a few months ago that the chart filter functionality might soon be available in Tabular report? Is it true?

Do you have any news about the progress of this feature or a roadmap for it?

Or maybe it's not planned, and I just didn't understand correctly.

 

Thank you very much,

Florian

Andrew_Kruger
Employee
Employee

Thanks for the post. 

In Qlik Cloud Analytics for "like" capability you can consider using Alternate states - have a look at the filtering section here  https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/cloud-in-app-r...

Feel free to add the interest for Object level filters to Ideation.  As far as cloud reporting goes Ideation is up to date for idea lifecycle status.  

florian63
Contributor II
Contributor II
Author

Hello Andrew,
Thank you very much for your reply. I'm going to look into the possibilities offered by the alternate states.

We followed your recommendation and created an idea, which you can find at the following address:

Request | Feedback 

 

As a workaround, can we overcome this problem with automation? or Pixelperfect ? 

 

Thank you, Florian

Andrew_Kruger
Employee
Employee

Please see the post here for an example of using Alternate States for the purpose of an object based field reduction.  https://community.qlik.com/t5/Qlik-Reporting-Service/Filtering-an-object-in-a-report-Tabular-and-Pix...