topic Re: Filtering between two data connections in QlikView https://community.qlik.com/t5/QlikView/Filtering-between-two-data-connections/m-p/1356492#M822300 <HTML><HEAD></HEAD><BODY><P>Assuming you are having a date field in your datamodel,</P><P></P><P>AGGR(concat({&lt;DateField={'&gt;=$(=MonthStart(Today(2)))&lt;=$(MonthEnd(Today(2)))}&gt;}Distinct project_name),project_name)</P><P></P><P>hth</P><P>Sasi</P></BODY></HTML> Sat, 05 Aug 2017 04:51:09 GMT sasiparupudi1 2017-08-05T04:51:09Z Filtering between two data connections https://community.qlik.com/t5/QlikView/Filtering-between-two-data-connections/m-p/1356491#M822299 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have a qlikview document where in the script i am pulling from an ODBC connection (JIRA) and an Excel file (MPWR). I have joined the the two but linking project name. I am trying to build a straight table where I can see projects that are in (MPWR) but not in (JIRA) and I only want to see project in the current month.&nbsp; </P><P></P><P>Below is the Calculated Dimension I am using to filter for projects in (MPWR) but not in (JIRA) how would i add on the current month into that formula?</P><P></P><P>=AGGR(concat(Distinct project_name),project_name)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Filtering-between-two-data-connections/m-p/1356491#M822299 mparker123 2020-11-25T16:16:04Z Re: Filtering between two data connections https://community.qlik.com/t5/QlikView/Filtering-between-two-data-connections/m-p/1356492#M822300 <HTML><HEAD></HEAD><BODY><P>Assuming you are having a date field in your datamodel,</P><P></P><P>AGGR(concat({&lt;DateField={'&gt;=$(=MonthStart(Today(2)))&lt;=$(MonthEnd(Today(2)))}&gt;}Distinct project_name),project_name)</P><P></P><P>hth</P><P>Sasi</P></BODY></HTML> Sat, 05 Aug 2017 04:51:09 GMT https://community.qlik.com/t5/QlikView/Filtering-between-two-data-connections/m-p/1356492#M822300 sasiparupudi1 2017-08-05T04:51:09Z