Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

Labels (2)
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())