Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are currently using Qlikview 11.20 SR11 and am trying to see if there is a way that we can use values from one chart in another.
Example:
Data (8 records)
SHAPE COLOR SIZE
Circle Blue Small
Circle Blue Medium
Triangle Blue Large
Triangle Red Medium
Circle Red Large
Square Blue Small
Square Blue Medium
Square Red Large
Current Selections:
SHAPE: Circle, Square
Color: Blue
Object 1: (4 records)
SHAPE COLOR SIZE
Circle Blue Small
Circle Blue Medium
Triangle Blue Large
Triangle Red Medium
Circle Red Large
Square Blue Small
Square Blue Medium
Square Red Large
I want to take the values for SHAPE in object 1 and apply to another object but as the only filter so that you end up with the following:
Object 2: (6 records)
SHAPE COLOR SIZE
Circle Blue Small
Circle Blue Medium
Triangle Blue Large
Triangle Red Medium
Circle Red Large
Square Blue Small
Square Blue Medium
Square Red Large
Is there a way to do this??
QlikView works applying filters to Data Model, not to objects.
You can´t use the result of an object as input to another.
What you can do is having variables that implements Set Analysis expressions and reuse those variables into both objects