Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I use dataset from one chart in another?

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

1 Reply
Clever_Anjos
Employee
Employee

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