Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kavieweg
New Contributor II

Set Value in a Filter for some cases

I want to set a Value or a range of Values in a filter pane if I select a value of another filter. Is that possible in Qlik Sense?

6 Replies
MVP
MVP

Re: Set Value in a Filter for some cases

The associative model can do that for you. But the values will be white not green - so they are "possible" and not selected. The effect is more or less the same though when it comes to calculations.

kavieweg
New Contributor II

Re: Set Value in a Filter for some cases

But when i have 2 filter:

First:

A

B

C

Second:

One

Two

Three

When A than select  One and Two

When B  than select Three

MVP
MVP

Re: Set Value in a Filter for some cases

The simplest form of association is to have the fields in the same table.

Try this in your load script:

TABLE:

LOAD * INLINE [

First, Second

A, One

A, Two

B, Three

C, Four

C, Four

C, Four

];

Then create two filter boxes with each of the two fields and have a look at how it behaves when you select in one or the other.

kavieweg
New Contributor II

Re: Set Value in a Filter for some cases

And how can I join Second to a field of another table?

MVP
MVP

Re: Set Value in a Filter for some cases

By a common field. Such a field is called a key and it connects the tables. It has the same name in both or all tables that will be connected.

MVP
MVP

Re: Set Value in a Filter for some cases

Community Browser