Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
villegasi03
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
Frank_Hartmann
Master II
Master II

can u share the qvw?

Saravanan_Desingh

Can you try this in the background?

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