https://community.qlik.com/t5/Qlik-Automate/Comparing-values-by-date/m-p/1988323#M907 <P>Dear All</P> <P>&nbsp;</P> <P>how can I compare 2 values by date range for example if in March 2022 there is a value of 1,2,3 or B and to check if a corresponding value exists in the consecutive &nbsp;month I.e April 2022 if 1,2,3 or B&nbsp;</P> <P>if there is a match return TRUE else return FALSE</P> <P>&nbsp;</P> <P>many thanks for your help and kind regards&nbsp;</P> Mon, 03 Oct 2022 18:23:06 GMT Razwan_S 2022-10-03T18:23:06Z https://community.qlik.com/t5/Qlik-Automate/Comparing-values-by-date/m-p/1988323#M907 <P>Dear All</P> <P>&nbsp;</P> <P>how can I compare 2 values by date range for example if in March 2022 there is a value of 1,2,3 or B and to check if a corresponding value exists in the consecutive &nbsp;month I.e April 2022 if 1,2,3 or B&nbsp;</P> <P>if there is a match return TRUE else return FALSE</P> <P>&nbsp;</P> <P>many thanks for your help and kind regards&nbsp;</P> Mon, 03 Oct 2022 18:23:06 GMT https://community.qlik.com/t5/Qlik-Automate/Comparing-values-by-date/m-p/1988323#M907 Razwan_S 2022-10-03T18:23:06Z https://community.qlik.com/t5/Qlik-Automate/Comparing-values-by-date/m-p/1988360#M908 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/189513">@Razwan_S</a>&nbsp;</P> <P>i would go for setAnalysis and operators</P> <P>* sign can work for you</P> <P><A href="https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-operators.htm" target="_blank">https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-operators.htm</A></P> <P>&nbsp;</P> <P>best,</P> Mon, 03 Oct 2022 20:53:15 GMT https://community.qlik.com/t5/Qlik-Automate/Comparing-values-by-date/m-p/1988360#M908 RafaelBarrios 2022-10-03T20:53:15Z