Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Intersecting Numbers Matrix

I've created a "payout" matrix via a CrossTable I pulled in. Y axis shows number of agents with 10K in sales while the X-Axis represents the number of new agent contracted. Essentially a manager would get paid a dollar amount where the two numbers intersect. In order to test I setup 2 variables to mimic a manager's results. 

My question is how can I highlight the box where the two variables intersect. I have attached a image of what I have so far. 

Any assistant with this would be very much appreciated. test_matrix.PNG

2 Replies
Highlighted
Master II
Master II

can u share the qvw?

Highlighted
Specialist III
Specialist III

Can you try this in the background?

If(NEW_AGENTS=vNewAgents And 10K_AGENTS=v10KAgents, Yellow())