Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

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
Master II
Master II

can u share the qvw?


Can you try this in the background?

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