topic Set Analysis - Count for last Date with Data in App Development https://community.qlik.com/t5/App-Development/Set-Analysis-Count-for-last-Date-with-Data/m-p/115609#M8013 <HTML><HEAD></HEAD><BODY><P>All,</P><P></P><P>I'm trying to have something working like as follows:</P><P><IMG alt="Date - Data Date - Counts.PNG" class="jive-image image-1" src="/legacyfs/online/214621_Date - Data Date - Counts.PNG" style="height: auto;" /></P><P>Scenario description:</P><P>- Calendar Date has all dates</P><P>- Data Date has the dates when something actually happened</P><P>- Products Count is just that, the Product count for that date... Count(Distinct SomeID)</P><P>- Previous Count <STRONG>Should be</STRONG> the Product Count of the last date when something actually happened.</P><P>- Difference should be "Products Count - Previous Count"</P><P></P><P>The final Table should only have these columns:</P><P>- Calendar Date</P><P>- Products Count</P><P>- Difference</P><P></P><P>I've been trying several combinations using Aggr and Set Analysis, and I'm struggling with getting even the previous Data Date for a given Date.</P><P></P><P>Thanks in advance!</P><P></P><P>Agu.-</P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT AguWolkovicz 2021-12-22T15:42:54Z Set Analysis - Count for last Date with Data https://community.qlik.com/t5/App-Development/Set-Analysis-Count-for-last-Date-with-Data/m-p/115609#M8013 <HTML><HEAD></HEAD><BODY><P>All,</P><P></P><P>I'm trying to have something working like as follows:</P><P><IMG alt="Date - Data Date - Counts.PNG" class="jive-image image-1" src="/legacyfs/online/214621_Date - Data Date - Counts.PNG" style="height: auto;" /></P><P>Scenario description:</P><P>- Calendar Date has all dates</P><P>- Data Date has the dates when something actually happened</P><P>- Products Count is just that, the Product count for that date... Count(Distinct SomeID)</P><P>- Previous Count <STRONG>Should be</STRONG> the Product Count of the last date when something actually happened.</P><P>- Difference should be "Products Count - Previous Count"</P><P></P><P>The final Table should only have these columns:</P><P>- Calendar Date</P><P>- Products Count</P><P>- Difference</P><P></P><P>I've been trying several combinations using Aggr and Set Analysis, and I'm struggling with getting even the previous Data Date for a given Date.</P><P></P><P>Thanks in advance!</P><P></P><P>Agu.-</P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Count-for-last-Date-with-Data/m-p/115609#M8013 AguWolkovicz 2021-12-22T15:42:54Z