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.
