topic Set expression to get latest week Sales and Previous Quarter Sales in 2 different charts in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Set-expression-to-get-latest-week-Sales-and-Previous-Quarter/m-p/1401650#M8528 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>1. If i choose Quarter Year filter in my sheet, and depending on what Quarter Year i chose in the filter i want the latest Latest week sales of that quarter to be calculated.</P><P></P><P>2. I also want previous year sales value to be calculated. Previous Quarter Sales depending on what Quarter Year filter i choose.</P><P>Say if i choose Q3-2017 , it should display Q2-2017 Sales. If i choose Q1-2017, it should display Q4-2016.</P><P></P><P>However by default point 1 should display current work week sales in graph 1 and point 2 should display previous Quarter sales in graph 2.</P><P></P><P>Thanks for the help in advance</P></BODY></HTML> Sat, 23 Sep 2017 18:08:38 GMT sarasmonu 2017-09-23T18:08:38Z Set expression to get latest week Sales and Previous Quarter Sales in 2 different charts https://community.qlik.com/t5/Integration-Extension-APIs/Set-expression-to-get-latest-week-Sales-and-Previous-Quarter/m-p/1401650#M8528 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>1. If i choose Quarter Year filter in my sheet, and depending on what Quarter Year i chose in the filter i want the latest Latest week sales of that quarter to be calculated.</P><P></P><P>2. I also want previous year sales value to be calculated. Previous Quarter Sales depending on what Quarter Year filter i choose.</P><P>Say if i choose Q3-2017 , it should display Q2-2017 Sales. If i choose Q1-2017, it should display Q4-2016.</P><P></P><P>However by default point 1 should display current work week sales in graph 1 and point 2 should display previous Quarter sales in graph 2.</P><P></P><P>Thanks for the help in advance</P></BODY></HTML> Sat, 23 Sep 2017 18:08:38 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Set-expression-to-get-latest-week-Sales-and-Previous-Quarter/m-p/1401650#M8528 sarasmonu 2017-09-23T18:08:38Z Re: Set expression to get latest week Sales and Previous Quarter Sales in 2 different charts https://community.qlik.com/t5/Integration-Extension-APIs/Set-expression-to-get-latest-week-Sales-and-Previous-Quarter/m-p/1401651#M8529 <HTML><HEAD></HEAD><BODY><P>This might help</P><P></P><P><A href="https://community.qlik.com/docs/DOC-9162">Set Analysis for certain Point in Time</A></P></BODY></HTML> Sat, 23 Sep 2017 21:19:59 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Set-expression-to-get-latest-week-Sales-and-Previous-Quarter/m-p/1401651#M8529 davidganly 2017-09-23T21:19:59Z