https://community.qlik.com/t5/App-Development/count-sales-from-previous-month/m-p/1596986#M63129 <P>I currently have a table of sales and its date. I have created a field named month_1 which gets the previous month as shown below. Now I am trying to count the number of sales in every month. Sales are reported daily so I will need to sum them up. I want to have a list of month mapped with last month's sales. Any idea how can I do that?</P><P>Currently I am using:</P><P>=count({&lt;[Date]={month_1}&gt;}Sales)</P><P>but it's not working</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="22.PNG" style="width: 229px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14600i8493B2EB2868CCAB/image-size/large?v=v2&amp;px=999" role="button" title="22.PNG" alt="22.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="11.PNG" style="width: 295px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14603iA0341B9E3A3761C2/image-size/large?v=v2&amp;px=999" role="button" title="11.PNG" alt="11.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="65.PNG" style="width: 306px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14602iBFE585D7892605AB/image-size/large?v=v2&amp;px=999" role="button" title="65.PNG" alt="65.PNG" /></span></P> Fri, 02 Apr 2021 07:59:20 GMT rainstorm90 2021-04-02T07:59:20Z https://community.qlik.com/t5/App-Development/count-sales-from-previous-month/m-p/1596986#M63129 <P>I currently have a table of sales and its date. I have created a field named month_1 which gets the previous month as shown below. Now I am trying to count the number of sales in every month. Sales are reported daily so I will need to sum them up. I want to have a list of month mapped with last month's sales. Any idea how can I do that?</P><P>Currently I am using:</P><P>=count({&lt;[Date]={month_1}&gt;}Sales)</P><P>but it's not working</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="22.PNG" style="width: 229px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14600i8493B2EB2868CCAB/image-size/large?v=v2&amp;px=999" role="button" title="22.PNG" alt="22.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="11.PNG" style="width: 295px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14603iA0341B9E3A3761C2/image-size/large?v=v2&amp;px=999" role="button" title="11.PNG" alt="11.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="65.PNG" style="width: 306px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14602iBFE585D7892605AB/image-size/large?v=v2&amp;px=999" role="button" title="65.PNG" alt="65.PNG" /></span></P> Fri, 02 Apr 2021 07:59:20 GMT https://community.qlik.com/t5/App-Development/count-sales-from-previous-month/m-p/1596986#M63129 rainstorm90 2021-04-02T07:59:20Z https://community.qlik.com/t5/App-Development/count-sales-from-previous-month/m-p/1597672#M63130 <P>Hi,</P><P>Or you need to place this value in a variable. Or you need a filter pane where you can filter on Month_1. Then you can just use Sum(Sales). You can't count Sales because then you count the rows and not the values in the rows.</P><P>Jordy</P><P>Climber</P> Mon, 01 Jul 2019 12:24:52 GMT https://community.qlik.com/t5/App-Development/count-sales-from-previous-month/m-p/1597672#M63130 JordyWegman 2019-07-01T12:24:52Z