topic Comparing field and variable in set analysis in QlikView https://community.qlik.com/t5/QlikView/Comparing-field-and-variable-in-set-analysis/m-p/1412605#M817613 <HTML><HEAD></HEAD><BODY><P>Dear Colleagues,</P><P></P><P>I have to calculate all the production orders which release date (field "DATA_EMISSAO_OS") has happened before a set date (variable called "vData_OS").</P><P></P><P>For that, I am using the following set analysis formula, but its not working.</P><P></P><P>Count(DISTINCT <SPAN style="font-size: 13.3333px;">{&lt;[DATA_EMISSAO_OS] = {"&lt;=$(vData_OS)"}&gt;}</SPAN>&nbsp; ID)</P><P></P><P>Is there any of you who can help me out with that issue?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Comparing field and variable in set analysis https://community.qlik.com/t5/QlikView/Comparing-field-and-variable-in-set-analysis/m-p/1412605#M817613 <HTML><HEAD></HEAD><BODY><P>Dear Colleagues,</P><P></P><P>I have to calculate all the production orders which release date (field "DATA_EMISSAO_OS") has happened before a set date (variable called "vData_OS").</P><P></P><P>For that, I am using the following set analysis formula, but its not working.</P><P></P><P>Count(DISTINCT <SPAN style="font-size: 13.3333px;">{&lt;[DATA_EMISSAO_OS] = {"&lt;=$(vData_OS)"}&gt;}</SPAN>&nbsp; ID)</P><P></P><P>Is there any of you who can help me out with that issue?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Comparing-field-and-variable-in-set-analysis/m-p/1412605#M817613 Anonymous 2020-11-25T16:16:04Z Re: Comparing field and variable in set analysis https://community.qlik.com/t5/QlikView/Comparing-field-and-variable-in-set-analysis/m-p/1412606#M817614 <HTML><HEAD></HEAD><BODY><P>Does the date format of Field [DATA_EMISSAO_OS] match the date format of your variable??</P><P></P><P>Read the below thread</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/4394">Dates in Set Analysis</A></P></BODY></HTML> Wed, 30 Aug 2017 15:42:21 GMT https://community.qlik.com/t5/QlikView/Comparing-field-and-variable-in-set-analysis/m-p/1412606#M817614 vinieme12 2017-08-30T15:42:21Z