Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Highlighted
Contributor

How to apply one filter criteria for entire sheet

Hi, Say i have a dimension with name A and B.

I don't want end user to see this filter pane with name,

but all the charts and kpi within sheet1 should be for the value A.

and all the charts and kpi withiin sheet2 should be for the value B.

How to write set expression or if statement to achieve this.?

Tags (1)
15 Replies
Highlighted
MVP
MVP

Re: How to apply one filter criteria for entire sheet

Use set expressions:

A

Sum({<MyField = {'A'}>} Amount)

B

Sum({<MyField = {'B'}>} Amount)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Valued Contributor II

Re: How to apply one filter criteria for entire sheet

and use a variable tu put A or B

MyField = {'$(v)'}

so you have same charts

Highlighted
Contributor

Re: How to apply one filter criteria for entire sheet

See i have many charts, kpi, filter pane with different calculations,

the fitler pane which contains names A and B is no where present in the sheet. End user cannot see it.

But all the calculations should be pertaining for value A in sheet 1 and Value B in sheet 2

Highlighted
Contributor II

Re: How to apply one filter criteria for entire sheet

I experienced the painful when you have many measures (charts) and must define same set analysis on them.

I just think abt some solutions for this case:

1. Use set analysis, create master items for all measures, then we can duplicate them and edit quickly. Then use the separate master items in 2 sheets. Define some variables  might support edit more quickly (such as set A_sheet = A, B_sheet=B).

2. Handle them in data load, there will be a lot of ways to do that.

3. Raise this issue to Qlik, recommend them to have a kind of sheet variable or something which can limit the scope of filters and variables.

Highlighted
Partner
Partner

Re: How to apply one filter criteria for entire sheet

Hi,

You can create an action ->right click ->Properties->Triggers->On activate sheet(Add actions)->Add->Action type is selection->Action is Selection in field->in Filed give as Name and in Search string give as ='A'

and in onLeavesheet(add actions)->Add->Action Type is selection->Action is Clear all

Same thing apply in second sheet also with Name='B'

Highlighted
Contributor

Re: How to apply one filter criteria for entire sheet

Hi

I suggest do this at script-level, it'll be quick to develop & may have low response time for the user too

Highlighted
Contributor

Re: How to apply one filter criteria for entire sheet

What if user clears all or Select a filter value for B while on sheet-A

Highlighted
Honored Contributor II

Re: How to apply one filter criteria for entire sheet

Another way to achieve this is without a load of set analysis is to have two seperate apps and in the data load restrict the data to dimension A in one and B in the other.

Highlighted
Partner
Partner

Re: How to apply one filter criteria for entire sheet

we are not giving Name filter anywhere in the sheet