topic LY variable not working in App Development https://community.qlik.com/t5/App-Development/LY-variable-not-working/m-p/1400652#M32551 <HTML><HEAD></HEAD><BODY><P>Hi, I created a variable for CYTD revenue that works correctly:</P><P>Sum({$&lt;[%dateflag_$1]={1}, [%dateflag_CYTD]={1}, $(vExcludeDateFields)&gt;}&nbsp; [Transaction Line Gross Amount])</P><P></P><P>However, when I try to replicate this for LY revenue it is showing incorrect data:</P><P>Sum({$&lt;[%dateflag_$1]={1}, [%dateflag_LY]={1}, $(vExcludeDateFields)&gt;}&nbsp; [Transaction Line Gross Amount])</P><P></P><P>I noticed that the LY variable appears to be summing all revenue from LY through the current year. Any ideas as to what I need to do? Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 05 Oct 2017 14:24:26 GMT 2017-10-05T14:24:26Z LY variable not working https://community.qlik.com/t5/App-Development/LY-variable-not-working/m-p/1400652#M32551 <HTML><HEAD></HEAD><BODY><P>Hi, I created a variable for CYTD revenue that works correctly:</P><P>Sum({$&lt;[%dateflag_$1]={1}, [%dateflag_CYTD]={1}, $(vExcludeDateFields)&gt;}&nbsp; [Transaction Line Gross Amount])</P><P></P><P>However, when I try to replicate this for LY revenue it is showing incorrect data:</P><P>Sum({$&lt;[%dateflag_$1]={1}, [%dateflag_LY]={1}, $(vExcludeDateFields)&gt;}&nbsp; [Transaction Line Gross Amount])</P><P></P><P>I noticed that the LY variable appears to be summing all revenue from LY through the current year. Any ideas as to what I need to do? Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 05 Oct 2017 14:24:26 GMT https://community.qlik.com/t5/App-Development/LY-variable-not-working/m-p/1400652#M32551 2017-10-05T14:24:26Z Re: LY variable not working https://community.qlik.com/t5/App-Development/LY-variable-not-working/m-p/1400653#M32552 <HTML><HEAD></HEAD><BODY><P>Also, LYTD works fine too:</P><P></P><P>Sum({$&lt;[%dateflag_$1]={1}, [%dateflag_LYTD]={1}, $(vExcludeDateFields)&gt;}&nbsp; [Transaction Line Gross Amount])</P></BODY></HTML> Thu, 05 Oct 2017 14:29:25 GMT https://community.qlik.com/t5/App-Development/LY-variable-not-working/m-p/1400653#M32552 2017-10-05T14:29:25Z