topic Re: Added/Dropped Accounts Based on Date in QlikView https://community.qlik.com/t5/QlikView/Added-Dropped-Accounts-Based-on-Date/m-p/488401#M480764 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Wed, 06 Nov 2013 18:54:23 GMT Gysbert_Wassenaar 2013-11-06T18:54:23Z Added/Dropped Accounts Based on Date https://community.qlik.com/t5/QlikView/Added-Dropped-Accounts-Based-on-Date/m-p/488400#M480763 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am having an issue creating a bar chart based on the requirements. Basically I have some data stacked on top of each other, and based on the dates, I need to count the accounts that added each month, the accounts that are dropped each month.</P><P></P><P>I am getting stuck when I have to write an expression that compares the dates and look at whether the account exists or not in that month. I began using the Today function and the InMonth function but I realized that this will not work unless it is during an ideal situation where each month the data is loaded on the 30th.</P><P></P><P>I have attached an excel file with some dummy data and a qvw file with the bar chart and the two expressions that need to be filled in the end (Added &amp; Dropped)</P><P></P><P>Any help would be greatly appreciated.</P></BODY></HTML> Wed, 06 Nov 2013 18:04:19 GMT https://community.qlik.com/t5/QlikView/Added-Dropped-Accounts-Based-on-Date/m-p/488400#M480763 2013-11-06T18:04:19Z Re: Added/Dropped Accounts Based on Date https://community.qlik.com/t5/QlikView/Added-Dropped-Accounts-Based-on-Date/m-p/488401#M480764 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Wed, 06 Nov 2013 18:54:23 GMT https://community.qlik.com/t5/QlikView/Added-Dropped-Accounts-Based-on-Date/m-p/488401#M480764 Gysbert_Wassenaar 2013-11-06T18:54:23Z