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

Is there a way i can add a permanent filter to a specified sheet, other than including in set analysis

Is there a way i can add a permanent filter to a specified sheet, other than including in set analysis

2 Solutions

Accepted Solutions
stevejoyce
Specialist II
Specialist II

There is no "sheet filter".

If your QlikSense version is relatively recent, you can add an action to your sheet to make your desired selection(s).  

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Sheets/setting-shee...

 

View solution in original post

stevejoyce
Specialist II
Specialist II

It will automatically select a field, so it will look as if a user made that selection.

What do you mean by "but not displaying the filter panel in the visualization?"  If you mean the selection bar, you can create a field that is hidden... either using HidePrefix, HideSuffix or Tag field <fieldname> with $hidden, and use that in your sheet action...hidden fields will not display in selection bar.

View solution in original post

3 Replies
stevejoyce
Specialist II
Specialist II

There is no "sheet filter".

If your QlikSense version is relatively recent, you can add an action to your sheet to make your desired selection(s).  

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Sheets/setting-shee...

 

Qlikuser09
Creator II
Creator II
Author

Will this apply filter action to the sheet, same as selecting a filter manually but not displaying the filter panel in the visualization.

stevejoyce
Specialist II
Specialist II

It will automatically select a field, so it will look as if a user made that selection.

What do you mean by "but not displaying the filter panel in the visualization?"  If you mean the selection bar, you can create a field that is hidden... either using HidePrefix, HideSuffix or Tag field <fieldname> with $hidden, and use that in your sheet action...hidden fields will not display in selection bar.