Hello All,
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.
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?
=AGGR(concat(Distinct project_name),project_name)
