topic Sales data only less than current month in QlikView https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114058#M758878 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have sales data for 5 years 2013 to 2018.</P><P>Now i want to show sum(Sales) only for the years 2015,2016,2017 and for months less than current month</P><P></P><P>since the current month is August</P><P></P><P>i want to show sum of sales of 2015(Jan to July),2016(Jan to July),2017(Jan to July)</P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ajsjoshua 2020-11-25T16:16:04Z Sales data only less than current month https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114058#M758878 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have sales data for 5 years 2013 to 2018.</P><P>Now i want to show sum(Sales) only for the years 2015,2016,2017 and for months less than current month</P><P></P><P>since the current month is August</P><P></P><P>i want to show sum of sales of 2015(Jan to July),2016(Jan to July),2017(Jan to July)</P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114058#M758878 ajsjoshua 2020-11-25T16:16:04Z Re: Sales data only less than current month https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114059#M758879 <HTML><HEAD></HEAD><BODY><P>hello,</P><P>you can create flag</P><P><IMG alt="Screenshot_4.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/211612_Screenshot_4.png" style="height: 251px; width: 620px;" /></P><P>and then use this field in set analysis <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;flag={'1'}&gt;}Sales) </SPAN></P></BODY></HTML> Thu, 23 Aug 2018 11:55:13 GMT https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114059#M758879 ValeriyaBartosh 2018-08-23T11:55:13Z Re: Sales data only less than current month https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114060#M758880 <HTML><HEAD></HEAD><BODY><P>Maybe just select months and years in listboxes...</P></BODY></HTML> Thu, 23 Aug 2018 11:57:19 GMT https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114060#M758880 andrey_krylov 2018-08-23T11:57:19Z Re: Sales data only less than current month https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114061#M758881 <HTML><HEAD></HEAD><BODY><P>точняк)</P></BODY></HTML> Thu, 23 Aug 2018 12:07:33 GMT https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114061#M758881 ValeriyaBartosh 2018-08-23T12:07:33Z Re: Sales data only less than current month https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114062#M758882 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 23 Aug 2018 12:09:27 GMT https://community.qlik.com/t5/QlikView/Sales-data-only-less-than-current-month/m-p/114062#M758882 andrey_krylov 2018-08-23T12:09:27Z