topic Re: How to compare sales of 2 different date in App Development https://community.qlik.com/t5/App-Development/How-to-compare-sales-of-2-different-date/m-p/85470#M5677 <HTML><HEAD></HEAD><BODY><P>Use this extension:</P><P></P><P><A href="http://branch.qlik.com/#!/project/5697a878dcc497f80ed514bf" title="http://branch.qlik.com/#!/project/5697a878dcc497f80ed514bf">Qlik Branch</A></P></BODY></HTML> Sun, 02 Sep 2018 13:55:29 GMT BalaBhaskar_Qlik 2018-09-02T13:55:29Z How to compare sales of 2 different date https://community.qlik.com/t5/App-Development/How-to-compare-sales-of-2-different-date/m-p/85468#M5675 <HTML><HEAD></HEAD><BODY><P>‌Hi,</P><P>I want to create 2 filters for date selection and I can compare sales between 2 dates.</P><P>Thank for your help! </P></BODY></HTML> Sat, 01 Sep 2018 14:21:28 GMT https://community.qlik.com/t5/App-Development/How-to-compare-sales-of-2-different-date/m-p/85468#M5675 caovanhau1507 2018-09-01T14:21:28Z Re: How to compare sales of 2 different date https://community.qlik.com/t5/App-Development/How-to-compare-sales-of-2-different-date/m-p/85469#M5676 <HTML><HEAD></HEAD><BODY><P>Create second date filter as Alternative one two make selections as Individual and use this expression:</P><P></P><P>Sum({&lt;Date={"&gt;=$(=Date(Min(Date)))&lt;=$(=Date(Max({ToDate}Date)))"}&gt;} Sales)</P></BODY></HTML> Sun, 02 Sep 2018 13:54:02 GMT https://community.qlik.com/t5/App-Development/How-to-compare-sales-of-2-different-date/m-p/85469#M5676 BalaBhaskar_Qlik 2018-09-02T13:54:02Z Re: How to compare sales of 2 different date https://community.qlik.com/t5/App-Development/How-to-compare-sales-of-2-different-date/m-p/85470#M5677 <HTML><HEAD></HEAD><BODY><P>Use this extension:</P><P></P><P><A href="http://branch.qlik.com/#!/project/5697a878dcc497f80ed514bf" title="http://branch.qlik.com/#!/project/5697a878dcc497f80ed514bf">Qlik Branch</A></P></BODY></HTML> Sun, 02 Sep 2018 13:55:29 GMT https://community.qlik.com/t5/App-Development/How-to-compare-sales-of-2-different-date/m-p/85470#M5677 BalaBhaskar_Qlik 2018-09-02T13:55:29Z Re: How to compare sales of 2 different date https://community.qlik.com/t5/App-Development/How-to-compare-sales-of-2-different-date/m-p/85471#M5678 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>The Same can be achieved by comparitive analysis first create alternate states then create 2 list box and assign the created states to the concerned list box. create a chart and in expressions use the state in set analysis.</P><P>PFA sample.</P><P>Regards</P><P>Ritesh</P></BODY></HTML> Mon, 03 Sep 2018 07:03:06 GMT https://community.qlik.com/t5/App-Development/How-to-compare-sales-of-2-different-date/m-p/85471#M5678 Anonymous 2018-09-03T07:03:06Z