topic set analysis based on dates(Urgent) in QlikView https://community.qlik.com/t5/QlikView/set-analysis-based-on-dates-Urgent/m-p/1443326#M797240 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am new to qlikview and need your help.</P><P>I need make a chart for returned sales.</P><P>The condition is closed date - opened date less than 20 days.</P><P>How would i do it in set analysis?</P><P>Please help me</P><P></P><P>Thanks &amp; Regards,</P><P>Jaya</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z set analysis based on dates(Urgent) https://community.qlik.com/t5/QlikView/set-analysis-based-on-dates-Urgent/m-p/1443326#M797240 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am new to qlikview and need your help.</P><P>I need make a chart for returned sales.</P><P>The condition is closed date - opened date less than 20 days.</P><P>How would i do it in set analysis?</P><P>Please help me</P><P></P><P>Thanks &amp; Regards,</P><P>Jaya</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/set-analysis-based-on-dates-Urgent/m-p/1443326#M797240 Anonymous 2020-11-25T16:16:04Z Re: set analysis based on dates(Urgent) https://community.qlik.com/t5/QlikView/set-analysis-based-on-dates-Urgent/m-p/1443327#M797241 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Sum(If(([closed date]-[opened date])&lt;20,[returned sales]))</STRONG></P><P><STRONG>OR</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>If((<STRONG style="font-size: 13.3333px;">[closed date]-[opened date])&lt;20, 1,0) as Flag</STRONG></STRONG></P><P>Expression is this?<STRONG><BR /></STRONG></P><P><STRONG>Sum({&lt;Flag = {1}&gt;} [returned sales])</STRONG></P></BODY></HTML> Thu, 07 Dec 2017 17:31:09 GMT https://community.qlik.com/t5/QlikView/set-analysis-based-on-dates-Urgent/m-p/1443327#M797241 Anil_Babu_Samineni 2017-12-07T17:31:09Z