Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @P_qlik
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
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:
If this does not help, I would suggest that you clarify your requirement further with
Kind regards...
Make sure to remove the 'report' filter in the above case.
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?
Hi @P_qlik
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
Perfect, thank you!