Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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?

saran7de
Master
Master

Can you try this in the background?

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