https://community.qlik.com/t5/App-Development/Date-Calculation-Fails-in-Chart-Expression-to-Filter-Dimension/m-p/1760846#M58823 <P>I have a strange issue. When I use a text chart object, I am able to calculate the difference between two dates:</P><P>Max(WarrantyDate) - Min(WarrantyDate): 11/10/2020 - 11/08/2020&nbsp; = 2</P><P>However, when I try the same thing for a chart table dimension filter, it doesn't work:</P><P>If(Num(Max(WarrantyDate) - Min(WarrantyDate)) = [Number Warranty Days],&nbsp;&nbsp;[Number Warranty Days])</P><P>The subtraction to determine the date difference doesn't work.&nbsp; I have tried using a variable to store the difference and reference it but while it works for displaying the result in a text object, it also is useless in a chart expression.</P><P>&nbsp;</P> Wed, 11 Nov 2020 18:11:41 GMT FerdiSisko 2020-11-11T18:11:41Z https://community.qlik.com/t5/App-Development/Date-Calculation-Fails-in-Chart-Expression-to-Filter-Dimension/m-p/1760846#M58823 <P>I have a strange issue. When I use a text chart object, I am able to calculate the difference between two dates:</P><P>Max(WarrantyDate) - Min(WarrantyDate): 11/10/2020 - 11/08/2020&nbsp; = 2</P><P>However, when I try the same thing for a chart table dimension filter, it doesn't work:</P><P>If(Num(Max(WarrantyDate) - Min(WarrantyDate)) = [Number Warranty Days],&nbsp;&nbsp;[Number Warranty Days])</P><P>The subtraction to determine the date difference doesn't work.&nbsp; I have tried using a variable to store the difference and reference it but while it works for displaying the result in a text object, it also is useless in a chart expression.</P><P>&nbsp;</P> Wed, 11 Nov 2020 18:11:41 GMT https://community.qlik.com/t5/App-Development/Date-Calculation-Fails-in-Chart-Expression-to-Filter-Dimension/m-p/1760846#M58823 FerdiSisko 2020-11-11T18:11:41Z