topic How to count everything but current month in QlikView https://community.qlik.com/t5/QlikView/How-to-count-everything-but-current-month/m-p/721625#M259094 <HTML><HEAD></HEAD><BODY><P><BR />ok. I have to count the distinct number of users for the current month and compare that to the total users that have ever been seen.</P><P></P><P>The calculation is easy, but what I'd like to do is when the user selects a different period, I'd like to have this calculation be correct for the total number of users that have ever been seen with respect to the month selected.</P></BODY></HTML> Fri, 20 Jun 2014 20:37:07 GMT 2014-06-20T20:37:07Z How to count everything but current month https://community.qlik.com/t5/QlikView/How-to-count-everything-but-current-month/m-p/721625#M259094 <HTML><HEAD></HEAD><BODY><P><BR />ok. I have to count the distinct number of users for the current month and compare that to the total users that have ever been seen.</P><P></P><P>The calculation is easy, but what I'd like to do is when the user selects a different period, I'd like to have this calculation be correct for the total number of users that have ever been seen with respect to the month selected.</P></BODY></HTML> Fri, 20 Jun 2014 20:37:07 GMT https://community.qlik.com/t5/QlikView/How-to-count-everything-but-current-month/m-p/721625#M259094 2014-06-20T20:37:07Z Re: How to count everything but current month https://community.qlik.com/t5/QlikView/How-to-count-everything-but-current-month/m-p/721626#M259095 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=Count({1-$} Distinct User)</P></BODY></HTML> Fri, 20 Jun 2014 21:31:47 GMT https://community.qlik.com/t5/QlikView/How-to-count-everything-but-current-month/m-p/721626#M259095 swuehl 2014-06-20T21:31:47Z Re: How to count everything but current month https://community.qlik.com/t5/QlikView/How-to-count-everything-but-current-month/m-p/721627#M259096 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Something like this for total user</P><P></P><P></P><P>Count({&lt;Period=&gt;} Total User)</P><P></P><P>regards,</P></BODY></HTML> Sat, 21 Jun 2014 07:45:23 GMT https://community.qlik.com/t5/QlikView/How-to-count-everything-but-current-month/m-p/721627#M259096 PrashantSangle 2014-06-21T07:45:23Z