Selection should not reflect another charts on the same sheet

[UserID2626]

hi everyone,

     i am using two filter pane on the same sheet. by selecting one value in one filter is reflecting another.i dont want that to reflect.

And also i want to make atlease one value as mandatory selection.

Thanks in advance

[gianpaolo_31]

I think you can use set analysis on this.

[YoussefBelloum · Accepted solution]

Hi,

would you be able to add more details ? Set analysis and alternate state can help you here

[UserID2626]

kept two filter pane for position.

if i select manager in one fiter it reflecting another filter pane also.

how to remove that.

attaching the very simple app in question itself.

[ChennaiahNallani]

try like below.

Example 

LOAD

    "Financial Month",

    "Financial Month" as "Financial Month Name",

    "Financial Qtr",

    "Financial Year",

    "Gross Premium"

FROM [lib://data/data1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Filter1 -- "Financial Month"

Filter2 -- "Financial Month Name"

Chart1 -- Dimension  : "Financial Month"

Measure :  Sum({<[Financial Month Name]>}[Gross Premium])

Chart2 -- Dimension  : "Financial Month Name"

Measure :  Sum({<[Financial Month]>}[Gross Premium])

[gianpaolo_31]

try below script:

QUALIFY *;

sample:

load * inline

[

empid, name, job_location, position1

1,xxx,US,Developer

2,yyyy,china,developer

3,aaaa,US,testing

4,bbbb,germany,Manager

];

t2:

NoConcatenate

load * inline

[

empid, name, job_location, position2

1,xxx,US,Developer

2,yyyy,china,developer

3,aaaa,US,testing

4,bbbb,germany,Manager

];

[vijetas42]

to restrict one chart reflect selection from filter pane you need to bypass those values in expression of chart.

suppose you have chart expression as sum(sales) and you want year which is your filter should not reflect in chart then expression should be,

sum({<year>}sales)

hope this may help!

[balabhaskarqlik]

Linking objects is the better option in Qlikview, In QlikSense it can be achieved by Master items but not completely.

Check this:

Using Alternate State in QLikSense (without Extensions)