How to apply one filter criteria for entire sheet

[deepak_km9886]

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

[jonathandienst]

Use set expressions:

A

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

B

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

[ogautier62]

and use a variable tu put A or B

MyField = {'$(v)'}

so you have same charts

[deepak_km9886]

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]

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]

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]

Hi

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

[thevingo]

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

[ogster1974]

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]

we are not giving Name filter anywhere in the sheet