Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vivethakumar
New Contributor

Selection should not reflect another charts on the same sheet

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

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: Selection should not reflect another charts on the same sheet

Hi,

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

7 Replies
gianpaolo_31
New Contributor III

Re: Selection should not reflect another charts on the same sheet

I think you can use set analysis on this.

YoussefBelloum
Esteemed Contributor

Re: Selection should not reflect another charts on the same sheet

Hi,

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

vivethakumar
New Contributor

Re: Selection should not reflect another charts on the same sheet

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
Contributor III

Re: Selection should not reflect another charts on the same sheet

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
New Contributor III

Re: Selection should not reflect another charts on the same sheet

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

];

vijetasharma
Contributor III

Re: Selection should not reflect another charts on the same sheet

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
Honored Contributor

Re: Selection should not reflect another charts on the same sheet

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)

Community Browser