topic Re: how to show filter applied on a single table object in Qlik NPrinting

how to show filter applied on a single table object

P_qlik — Tue, 06 Apr 2021 13:22:57 GMT

Hi,

I have and excel report with some sheet, each sheet has a table object with a different filter applied.

I need to show on the top of each sheet the selection and filter applied to each table object, usually when I apply filter to the whole report I use GetCurrentSelections on the formula and it works but in this case it doesn't work because I don't have filter applied to the whole report but I have different filter applied to each table object, how can I do?

Thank you

Re: how to show filter applied on a single table object

Frank_S — Tue, 06 Apr 2021 22:41:06 GMT

To be honest @P_qlik it is not abundantly clear what your requirement is.

So I will just make some suggestions to try to help you based on what I 'think' you requirement is:

Add a current selections box in your QlikView Document, reload the NP connection then add this box to your NP report to see current selections in the report
Create a filter you want to use on your table object and apply each filter to each table object as needed. See image below. Detailed instructions here: https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-12
Repeat for each sheet in your excel report

If this does not help, I would suggest that you clarify your requirement further with

Detailed steps to reproduce
What are your expected results: (provide description and mock up image)
What are you actual results: (provide description and image

Kind regards...

Re: how to show filter applied on a single table object

Frank_S — Tue, 06 Apr 2021 22:41:37 GMT

Make sure to remove the 'report' filter in the above case.

Re: how to show filter applied on a single table object

P_qlik — Wed, 07 Apr 2021 07:22:14 GMT

Hi @Frank_S , thank you for the answer.

What I need is something that says what selections are applied on table object, for example if on table object CH187 I applied a filter 2016, I need to see written something like "current selection: 2016",.

Is it possible to do?

Re: how to show filter applied on a single table object

Ruggero_Piccoli — Wed, 07 Apr 2021 08:21:04 GMT

Hi @P_qlik

create a text object in the connected QlikView document
insert on it a GetCurrentSelections() customized based on your needs https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/getcurrentselections.htm
refresh the connection cache and when finished close and reopen the Designer
add the text object as image, apply the object filter to it and drag and drop into the template
add the table object, apply the object filter and drag and drop it into the template
run a preview

You need to add an object with the GetCurrentSelections() formula and the same object filter of the table. You cannot simply add the GetCurrentSelections() as formula because it will not show the object filter selections.

Best Regards,

Ruggero

Re: how to show filter applied on a single table object

P_qlik — Wed, 07 Apr 2021 08:35:33 GMT

Perfect, thank you!