https://community.qlik.com/t5/Data-Quality/How-to-get-records-sysdate-1-from-a-dimension/m-p/2209240#M1116 <P>How i can add sysdate -1 condition in pa_uha_ledger dimension to get only sysdate-1 records </P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000UxehrAAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131773i535EDB375465D95C/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000UxehrAAB.png" alt="0695b00000UxehrAAB.png" /></span></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P> Fri, 15 Nov 2024 22:37:21 GMT MAfridi1650945823 2024-11-15T22:37:21Z https://community.qlik.com/t5/Data-Quality/How-to-get-records-sysdate-1-from-a-dimension/m-p/2209240#M1116 <P>How i can add sysdate -1 condition in pa_uha_ledger dimension to get only sysdate-1 records </P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000UxehrAAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131773i535EDB375465D95C/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000UxehrAAB.png" alt="0695b00000UxehrAAB.png" /></span></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P> Fri, 15 Nov 2024 22:37:21 GMT https://community.qlik.com/t5/Data-Quality/How-to-get-records-sysdate-1-from-a-dimension/m-p/2209240#M1116 MAfridi1650945823 2024-11-15T22:37:21Z https://community.qlik.com/t5/Data-Quality/How-to-get-records-sysdate-1-from-a-dimension/m-p/2209241#M1117 <P>You would do this in exactly the same way you would achieve this using SQL. Add the WHERE Clause to your SQL query.</P> Thu, 25 Aug 2022 09:47:14 GMT https://community.qlik.com/t5/Data-Quality/How-to-get-records-sysdate-1-from-a-dimension/m-p/2209241#M1117 Anonymous 2022-08-25T09:47:14Z