Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rekha_jv
New Contributor III

Separate One Sheet filter from the other Sheet

Hi,

I am new to Qlik Sense. Could any one help me to Separate Sheet 1 from Sheet 2. I mean the filters of Sheet 1 should not affect Sheet 2, similarly filters of sheet 2 should not affect sheet 1

Thank you in advance.

Rekha

6 Replies
shraddha_g
Honored Contributor III

Re: Separate One Sheet filter from the other Sheet

In sheet2 , you can nulify selections in all expressions

agigliotti
Honored Contributor II

Re: Separate One Sheet filter from the other Sheet

rekha_jv
New Contributor III

Re: Separate One Sheet filter from the other Sheet

could you please provide the steps in detail?

amarnath_krishn
New Contributor III

Re: Separate One Sheet filter from the other Sheet

May be Sheet Navigation extension would be of assistance here. It would allow you to clear your selections when you move away from a sheet.

GitHub - stefanwalther/sense-navigation: Sheet Navigation + Actions for Qlik Sense.

But the catch is you should force your users to navigate using the buttons on your sheet rather than switching sheets using default Qlik Sense options.

shraddha_g
Honored Contributor III

Re: Separate One Sheet filter from the other Sheet

sum({<SelecteFieldName1=,SelectedFieldName2=>}ValueField)

Employee
Employee

Re: Separate One Sheet filter from the other Sheet

Dear Rekha,

The default behavior on Qlik Products Engine is to create a simple data model, connecting multiple data sources each others by a commom named field. If you are using the same field on different sheets, the normal process is apply filter on both. But, if you want to create multiple visualizations, you could use set analysis or other extensions.

Set analysis and set expressions ‒ Qlik Sense

Ricardo Gerhard
OEM Solution Architect
LATAM
Community Browser