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: 
QlikSense_Best
Contributor
Contributor

Pivot Table Comparable Values

Hi all,

I want to create a pivot table that displays all values and metrics for ex:

I have a dimension with stock labels: AAPL, BBBY, BEN, etc...

I want to show a second dimension that displays whether another stock falls within that criteria.

 

So if AAPL is say $5, BBBY is $3, and BEN is $10.

I want the second dimension of the pivot to show stocks that are within $2 of each other.

Under AAPL it will show BBBY

Under BBBY it will show AAPL

Under BEN it will show nothing. 

Is this possible in Qlik? Thank you.

Labels (5)
0 Replies