Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sandhya_7
Contributor II
Contributor II

Is it possible to Restrict the selected filters from my dashboard to other detailed report sheets using buttons

I am able to carryover the filters from main dashboards to other report sheets using this expression-

'/select/' & GetCurrentSelections('/select/','/',';')

but I want to Restrict the selected filters from my dashboard to detailed reports sheets only when those filters are not available in detailed reports and I should not get any error like field is not found.

For Example:

I am having Project, Event and Category filters in my dashboard.

Users are selecting Project and Events in 'my dashboard' and they are moving to 'detailed reports' by carrying same filters, but 'one of the detailed report' don't have 'Events' field so there it is showing "Event field is not Found" error.
Users are expecting that they should not see any errors.

Is there any way to restrict that filter in runtime itself without showing any error?


can anyone please suggest the solution for this.

 

Thanks in Advance.

Labels (2)
2 Replies
Nicolae_Alecu
Creator
Creator

Hello,

You can use Alternate States.

Check This Video: https://www.youtube.com/watch?v=tsbnG3tOdR4 

Another solution can be a "Clear all selections" Action on every sheet.

Nicolae_Alecu_0-1710447264388.png

Good Luck!

 

MatheusC
Specialist
Specialist

Hi, @Sandhya_7 

Also as a solution, use Data handling and display a message to the user requesting the removal of the filter and thus providing the appropriate information.

MatheusC_0-1710449161601.png

 



For example:
As a condition for displaying the graph, that is, it will only display the graph if it is not filtered by Event.

GetSelectedCount(Event)<1


Message
='Remove Event filter'

Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!