Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Creator II
Creator II

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

Hi,

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

View solution in original post

7 Replies
gianpaolo_31
Contributor III
Contributor III

I think you can use set analysis on this.

YoussefBelloum
Champion
Champion

Hi,

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

View solution in original post

UserID2626
Creator II
Creator II

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

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

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

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)