Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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
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.
And how can I join Second to a field of another table?
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.