Set Value in a Filter for some cases

[kavieweg]

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?

[petter]

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]

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

[petter]

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]

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

[petter]

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.

[petter]

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/managing-associations...