https://community.qlik.com/t5/App-Development/Sales-till-date/m-p/1818354#M67063 <P>Hi,</P><P>I have the date as in Posting_Date in format "DD-MM-YYYY".</P><P>I want to get sales of Year 2021 till date and previous Year but when I do so I get 0 value, (Maybe LHS != RHS)</P><P>Sum({$&lt;Posting_Dates={"&gt;=$(=Max(AddYears(Posting_Dates)))"}&gt;}Net_Sales_After_Discount)</P><P>No hardcode , so that data gets self Uploaded.</P><P>Should I Change format or declare variables or use If condition. Please Suggest.</P><P>Thanks,</P> Mon, 28 Jun 2021 15:32:34 GMT Vaibhav_Tyagi 2021-06-28T15:32:34Z https://community.qlik.com/t5/App-Development/Sales-till-date/m-p/1818354#M67063 <P>Hi,</P><P>I have the date as in Posting_Date in format "DD-MM-YYYY".</P><P>I want to get sales of Year 2021 till date and previous Year but when I do so I get 0 value, (Maybe LHS != RHS)</P><P>Sum({$&lt;Posting_Dates={"&gt;=$(=Max(AddYears(Posting_Dates)))"}&gt;}Net_Sales_After_Discount)</P><P>No hardcode , so that data gets self Uploaded.</P><P>Should I Change format or declare variables or use If condition. Please Suggest.</P><P>Thanks,</P> Mon, 28 Jun 2021 15:32:34 GMT https://community.qlik.com/t5/App-Development/Sales-till-date/m-p/1818354#M67063 Vaibhav_Tyagi 2021-06-28T15:32:34Z