https://community.qlik.com/t5/QlikView/query-converting-from-sql-into-qlikview-script/m-p/1594152#M738107 <P>CASE</P><P>WHEN</P><P>[Alternate Resolution Date(UTC/GMT)] IS NULL</P><P>THEN</P><P>(</P><P>CASE WHEN _days_between(current_timestamp,[ Target Resolution Date(UTC/GMT)]) &gt; 0 THEN 'Y' ELSE 'N' END</P><P>)</P><P>WHEN</P><P>[Alternate Resolution Date(UTC/GMT)] IS NOT NULL</P><P>THEN</P><P>(</P><P>CASE WHEN _days_between(current_timestamp,[ Alternate Resolution Date(UTC/GMT)]) &gt; 0 THEN 'Y' ELSE 'N'</P><P>END</P><P>)</P><P>END</P><P>&nbsp;</P><P>Cananyoneplease help me in qlikview script in if condition</P> Wed, 25 Nov 2020 16:16:04 GMT qlikapple 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/query-converting-from-sql-into-qlikview-script/m-p/1594152#M738107 <P>CASE</P><P>WHEN</P><P>[Alternate Resolution Date(UTC/GMT)] IS NULL</P><P>THEN</P><P>(</P><P>CASE WHEN _days_between(current_timestamp,[ Target Resolution Date(UTC/GMT)]) &gt; 0 THEN 'Y' ELSE 'N' END</P><P>)</P><P>WHEN</P><P>[Alternate Resolution Date(UTC/GMT)] IS NOT NULL</P><P>THEN</P><P>(</P><P>CASE WHEN _days_between(current_timestamp,[ Alternate Resolution Date(UTC/GMT)]) &gt; 0 THEN 'Y' ELSE 'N'</P><P>END</P><P>)</P><P>END</P><P>&nbsp;</P><P>Cananyoneplease help me in qlikview script in if condition</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/query-converting-from-sql-into-qlikview-script/m-p/1594152#M738107 qlikapple 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/query-converting-from-sql-into-qlikview-script/m-p/1594161#M738108 <P>May be this</P><LI-CODE lang="markup">If(Len(Trim([Alternate Resolution Date(UTC/GMT)])) = 0, If(current_timestamp - [ Target Resolution Date(UTC/GMT)] &gt; 0, 'Y', 'N'), If(current_timestamp - [ Alternate Resolution Date(UTC/GMT)]) &gt; 0, 'Y', 'N') )</LI-CODE> Thu, 20 Jun 2019 14:02:03 GMT https://community.qlik.com/t5/QlikView/query-converting-from-sql-into-qlikview-script/m-p/1594161#M738108 sunny_talwar 2019-06-20T14:02:03Z