topic Intersecting Numbers Matrix in QlikView Layout & Visualizations
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Intersecting-Numbers-Matrix/m-p/1696639#M71924
<P>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. </P><P>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. </P><P>Any assistant with this would be very much appreciated. <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="test_matrix.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32447i7E14A4CE95D98A95/image-size/large?v=1.0&px=999" role="button" title="test_matrix.PNG" alt="test_matrix.PNG" /></span></P>Fri, 24 Apr 2020 21:45:56 GMTvillegasi032020-04-24T21:45:56ZIntersecting Numbers Matrix
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Intersecting-Numbers-Matrix/m-p/1696639#M71924
<P>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. </P><P>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. </P><P>Any assistant with this would be very much appreciated. <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="test_matrix.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32447i7E14A4CE95D98A95/image-size/large?v=1.0&px=999" role="button" title="test_matrix.PNG" alt="test_matrix.PNG" /></span></P>Fri, 24 Apr 2020 21:45:56 GMThttps://community.qlik.com/t5/QlikView-Layout-Visualizations/Intersecting-Numbers-Matrix/m-p/1696639#M71924villegasi032020-04-24T21:45:56ZRe: Intersecting Numbers Matrix
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Intersecting-Numbers-Matrix/m-p/1696674#M71925
<P>can u share the qvw?</P>Sat, 25 Apr 2020 09:01:55 GMThttps://community.qlik.com/t5/QlikView-Layout-Visualizations/Intersecting-Numbers-Matrix/m-p/1696674#M71925Frank_Hartmann2020-04-25T09:01:55ZRe: Intersecting Numbers Matrix
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Intersecting-Numbers-Matrix/m-p/1706964#M72028
<P>Can you try this in the background?</P><LI-CODE lang="markup">If(NEW_AGENTS=vNewAgents And 10K_AGENTS=v10KAgents, Yellow())</LI-CODE><P> </P>Mon, 01 Jun 2020 02:10:46 GMThttps://community.qlik.com/t5/QlikView-Layout-Visualizations/Intersecting-Numbers-Matrix/m-p/1706964#M72028saran7de2020-06-01T02:10:46Z