topic Re: How to club two flag conditions in one if condition expression in QlikView https://community.qlik.com/t5/QlikView/How-to-club-two-flag-conditions-in-one-if-condition-expression/m-p/109182#M757300 <HTML><HEAD></HEAD><BODY><P>corrected</P><P></P><P>If( Flag0=0,[Computed ROB1], [ComputedROB2])</P><P></P><P>where Flag0=If([SOUNDING_START_DATE] &gt; [SURVEY_DATE]&nbsp; and [SOUNDING_START_DATE] &gt; [SURVEY_DATE] + 8 and [SOUNDING_START_DATE] &lt; [SURVEY_DATE] + 30, 1, 0)</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213141_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 10 Sep 2018 12:46:41 GMT trishita 2018-09-10T12:46:41Z How to club two flag conditions in one if condition expression https://community.qlik.com/t5/QlikView/How-to-club-two-flag-conditions-in-one-if-condition-expression/m-p/109181#M757299 <HTML><HEAD></HEAD><BODY><P> <IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213086_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>I have two flag options which I want to put under same column.Which means the column Computed ROB and Actual ROB will show in one and single column for flag values 0 and 1.However I had faced syntax error and some problems in approaching the same values...I have uploaded the qvw for the said functionality.</P><P></P><P></P><P>To be noted&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">Flag1=If([SOUNDING_START_DATE] &gt;= [SURVEY_DATE] and [SOUNDING_START_DATE] &lt; [SURVEY_DATE] + 8, 1, 0)</SPAN></P><P><SPAN style="color: #ff0000;">and <SPAN style="color: #0000ff;">Flag0=</SPAN><SPAN style="color: #0000ff;">If([SOUNDING_START_DATE] &gt; [SURVEY_DATE]&nbsp; and [SOUNDING_START_DATE] &gt; [SURVEY_DATE] + 8 and [SOUNDING_START_DATE] &lt; [SURVEY_DATE] + 30, 1, 0).</SPAN></SPAN></P><P><SPAN style="color: #ff0000;"><SPAN style="color: #000000;">​I am trying to computed the values of COMPUTED ROB and ACTUAL ROB values for same quantity but for two different time range.</SPAN><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-club-two-flag-conditions-in-one-if-condition-expression/m-p/109181#M757299 trishita 2020-11-25T16:16:04Z Re: How to club two flag conditions in one if condition expression https://community.qlik.com/t5/QlikView/How-to-club-two-flag-conditions-in-one-if-condition-expression/m-p/109182#M757300 <HTML><HEAD></HEAD><BODY><P>corrected</P><P></P><P>If( Flag0=0,[Computed ROB1], [ComputedROB2])</P><P></P><P>where Flag0=If([SOUNDING_START_DATE] &gt; [SURVEY_DATE]&nbsp; and [SOUNDING_START_DATE] &gt; [SURVEY_DATE] + 8 and [SOUNDING_START_DATE] &lt; [SURVEY_DATE] + 30, 1, 0)</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213141_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 10 Sep 2018 12:46:41 GMT https://community.qlik.com/t5/QlikView/How-to-club-two-flag-conditions-in-one-if-condition-expression/m-p/109182#M757300 trishita 2018-09-10T12:46:41Z