topic Re: Cummulative data display in QlikView https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293498#M872116 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P>I need to display count(Dept) for current year and previous year also in a text boxes.</P><P><SPAN style="font-size: 13.3333px;">I have other sheets need to change based on SalesDate Selection.</SPAN></P><P><SPAN style="font-size: 13.3333px;">How to achieve this?</SPAN></P><P>Please advise.</P></BODY></HTML> Thu, 24 Nov 2016 05:59:07 GMT 2016-11-24T05:59:07Z Cummulative data display https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293495#M872113 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have the data on Date level Sales and Dept Details.</P><P>I want to show the Dept Details based on SalesDate slection.</P><P></P><P>If I select SalesDate value - ToDate 12/31/2015, I want to show all the Dept Details of 2015.</P><P>If I select SalesDate value - ToDate 1/31/2016, I want to show Jan/2016 Dept Details.</P><P>If I select SalesDate value - ToDate 2/29/2016, I want to show cummulative of&nbsp; Jan/2016,Feb/216 Dept Details.</P><P>If I select SalesDate value - ToDate 3/31/2016, I want to show cummulative of&nbsp;&nbsp; Jan/2016,Feb/216,Mar/2016 Dept Details.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144603_Capture.PNG" style="height: auto;" /></P><P>How to achieve this?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293495#M872113 2020-11-25T16:16:04Z Re: Cummulative data display https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293496#M872114 <HTML><HEAD></HEAD><BODY><P>like this?</P></BODY></HTML> Wed, 23 Nov 2016 10:15:56 GMT https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293496#M872114 MK_QSL 2016-11-23T10:15:56Z Re: Cummulative data display https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293497#M872115 <HTML><HEAD></HEAD><BODY><P>Check This Out !</P></BODY></HTML> Wed, 23 Nov 2016 11:21:06 GMT https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293497#M872115 2016-11-23T11:21:06Z Re: Cummulative data display https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293498#M872116 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P>I need to display count(Dept) for current year and previous year also in a text boxes.</P><P><SPAN style="font-size: 13.3333px;">I have other sheets need to change based on SalesDate Selection.</SPAN></P><P><SPAN style="font-size: 13.3333px;">How to achieve this?</SPAN></P><P>Please advise.</P></BODY></HTML> Thu, 24 Nov 2016 05:59:07 GMT https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293498#M872116 2016-11-24T05:59:07Z Re: Cummulative data display https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293499#M872117 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Sunil,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have other sheets used SalesDate. Is it possible to achieve without alternate states.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-size: 11.7px;">Please advise.</STRONG></P></BODY></HTML> Thu, 24 Nov 2016 06:01:08 GMT https://community.qlik.com/t5/QlikView/Cummulative-data-display/m-p/1293499#M872117 2016-11-24T06:01:08Z