topic Filtering future months in QlikView https://community.qlik.com/t5/QlikView/Filtering-future-months/m-p/359736#M492196 <HTML><HEAD></HEAD><BODY><P>Hi, I'm relatively new at qlikview and I've been trying to filter future months to see if there's information saved in incorrect months (ex: It's impossible to spend money in October 2012 if we're in July 2012).</P><P>I'd like to count the number of transactions made in future months of the same year. This is the formula I've been trying to use:</P><P>=Count({&lt;transaction_Year={"=year(Today())"},transaction_Month={"&gt;month(Today())"}&gt;}Transaction)</P><P>It works fine with the year, but when I try to filter greater months (transaction_Month has a numerical value) it just doesn't work. I don't get an error in the expression, but the numbers are all to zero.</P><P></P><P>I would greatly appreciate any help.</P></BODY></HTML> Fri, 20 Jul 2012 07:49:18 GMT 2012-07-20T07:49:18Z Filtering future months https://community.qlik.com/t5/QlikView/Filtering-future-months/m-p/359736#M492196 <HTML><HEAD></HEAD><BODY><P>Hi, I'm relatively new at qlikview and I've been trying to filter future months to see if there's information saved in incorrect months (ex: It's impossible to spend money in October 2012 if we're in July 2012).</P><P>I'd like to count the number of transactions made in future months of the same year. This is the formula I've been trying to use:</P><P>=Count({&lt;transaction_Year={"=year(Today())"},transaction_Month={"&gt;month(Today())"}&gt;}Transaction)</P><P>It works fine with the year, but when I try to filter greater months (transaction_Month has a numerical value) it just doesn't work. I don't get an error in the expression, but the numbers are all to zero.</P><P></P><P>I would greatly appreciate any help.</P></BODY></HTML> Fri, 20 Jul 2012 07:49:18 GMT https://community.qlik.com/t5/QlikView/Filtering-future-months/m-p/359736#M492196 2012-07-20T07:49:18Z Re: Filtering future months https://community.qlik.com/t5/QlikView/Filtering-future-months/m-p/359737#M492197 <HTML><HEAD></HEAD><BODY><P>wont be better to make a Data field? and move the Year, Month....etc to master calendar?</P></BODY></HTML> Fri, 20 Jul 2012 08:37:52 GMT https://community.qlik.com/t5/QlikView/Filtering-future-months/m-p/359737#M492197 2012-07-20T08:37:52Z