topic Date comparison in set analysis in QlikView https://community.qlik.com/t5/QlikView/Date-comparison-in-set-analysis/m-p/926777#M320730 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have 2 tables, one with customers who have used a discount code, and another that has all purchases for all customers.</P><P></P><P>I wan't to calculate all the purchases a customer has made after the customer has used a discount code. So if a customers uses 2 discount codes, one sale could end up in two columns, one for each discount code, if the sale date is after both discount code dates.</P><P></P><P>Attached is a simple Excel with how my data looks like.</P></BODY></HTML> Fri, 14 Aug 2015 12:02:52 GMT Anonymous 2015-08-14T12:02:52Z Date comparison in set analysis https://community.qlik.com/t5/QlikView/Date-comparison-in-set-analysis/m-p/926777#M320730 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have 2 tables, one with customers who have used a discount code, and another that has all purchases for all customers.</P><P></P><P>I wan't to calculate all the purchases a customer has made after the customer has used a discount code. So if a customers uses 2 discount codes, one sale could end up in two columns, one for each discount code, if the sale date is after both discount code dates.</P><P></P><P>Attached is a simple Excel with how my data looks like.</P></BODY></HTML> Fri, 14 Aug 2015 12:02:52 GMT https://community.qlik.com/t5/QlikView/Date-comparison-in-set-analysis/m-p/926777#M320730 Anonymous 2015-08-14T12:02:52Z Re: Date comparison in set analysis https://community.qlik.com/t5/QlikView/Date-comparison-in-set-analysis/m-p/926778#M320731 <HTML><HEAD></HEAD><BODY><P>Can you also provide the result you are looking for in excel file?</P></BODY></HTML> Fri, 14 Aug 2015 12:07:59 GMT https://community.qlik.com/t5/QlikView/Date-comparison-in-set-analysis/m-p/926778#M320731 MK_QSL 2015-08-14T12:07:59Z Re: Date comparison in set analysis https://community.qlik.com/t5/QlikView/Date-comparison-in-set-analysis/m-p/926779#M320732 <HTML><HEAD></HEAD><BODY><P>I've added a third tab called "Result".</P></BODY></HTML> Fri, 14 Aug 2015 12:21:04 GMT https://community.qlik.com/t5/QlikView/Date-comparison-in-set-analysis/m-p/926779#M320732 Anonymous 2015-08-14T12:21:04Z Re: Date comparison in set analysis https://community.qlik.com/t5/QlikView/Date-comparison-in-set-analysis/m-p/926780#M320733 <HTML><HEAD></HEAD><BODY><P>Create a Straight Table</P><P>Dimension</P><P>UserID</P><P></P><P>Expression</P><P>SUM(IF(OrderDate &gt; DateUsedCode, Amount))</P></BODY></HTML> Fri, 14 Aug 2015 12:33:22 GMT https://community.qlik.com/t5/QlikView/Date-comparison-in-set-analysis/m-p/926780#M320733 MK_QSL 2015-08-14T12:33:22Z