Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

deepak_km9886
New Contributor III

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
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)

ogautier62
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

deepak_km9886
New Contributor III

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

thi_pham
Contributor

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.

hemeshreddy
New Contributor III

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'

thevingo
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

thevingo
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

ogster1974
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.

hemeshreddy
New Contributor III

Re: How to apply one filter criteria for entire sheet

we are not giving Name filter anywhere in the sheet

Community Browser