topic Dimension limitations to eliminate all rows under $50k in sales amount. in QlikView https://community.qlik.com/t5/QlikView/Dimension-limitations-to-eliminate-all-rows-under-50k-in-sales/m-p/1941884#M1219366 <P>Hello,</P> <P>I have a table that keys off of the measure sales amount. What I am wanting to do is create a dimension limitation that will eliminate all rows less than $50k for sales amount.&nbsp;</P> <P>Thanks,</P> <P>Josh</P> Thu, 09 Jun 2022 20:19:47 GMT JoshHazelton 2022-06-09T20:19:47Z Dimension limitations to eliminate all rows under $50k in sales amount. https://community.qlik.com/t5/QlikView/Dimension-limitations-to-eliminate-all-rows-under-50k-in-sales/m-p/1941884#M1219366 <P>Hello,</P> <P>I have a table that keys off of the measure sales amount. What I am wanting to do is create a dimension limitation that will eliminate all rows less than $50k for sales amount.&nbsp;</P> <P>Thanks,</P> <P>Josh</P> Thu, 09 Jun 2022 20:19:47 GMT https://community.qlik.com/t5/QlikView/Dimension-limitations-to-eliminate-all-rows-under-50k-in-sales/m-p/1941884#M1219366 JoshHazelton 2022-06-09T20:19:47Z Re: Dimension limitations to eliminate all rows under $50k in sales amount. https://community.qlik.com/t5/QlikView/Dimension-limitations-to-eliminate-all-rows-under-50k-in-sales/m-p/1941989#M1219370 <P>You can use the "Dimension limits" functionality and eliminate the unwanted results</P> Fri, 10 Jun 2022 07:36:53 GMT https://community.qlik.com/t5/QlikView/Dimension-limitations-to-eliminate-all-rows-under-50k-in-sales/m-p/1941989#M1219370 dapostolopoylos 2022-06-10T07:36:53Z Re: Dimension limitations to eliminate all rows under $50k in sales amount. https://community.qlik.com/t5/QlikView/Dimension-limitations-to-eliminate-all-rows-under-50k-in-sales/m-p/1942212#M1219381 <P>What is the limitation expression I would need to use?</P> <P>&nbsp;</P> Fri, 10 Jun 2022 13:11:08 GMT https://community.qlik.com/t5/QlikView/Dimension-limitations-to-eliminate-all-rows-under-50k-in-sales/m-p/1942212#M1219381 JoshHazelton 2022-06-10T13:11:08Z Re: Dimension limitations to eliminate all rows under $50k in sales amount. https://community.qlik.com/t5/QlikView/Dimension-limitations-to-eliminate-all-rows-under-50k-in-sales/m-p/1942368#M1219391 <P>You need at least one dimension (select the one you want), then...</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1941884.png" style="width: 462px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/81529i4218862D8A4C0B1C/image-size/large?v=v2&amp;px=999" role="button" title="1941884.png" alt="1941884.png" /></span></P> <P>HTH,</P> <P>John</P> <P>(aka johncaqc)</P> Fri, 10 Jun 2022 20:13:16 GMT https://community.qlik.com/t5/QlikView/Dimension-limitations-to-eliminate-all-rows-under-50k-in-sales/m-p/1942368#M1219391 Anonymous 2022-06-10T20:13:16Z