topic Re: Set analysis with calendar in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-with-calendar/m-p/30549#M458621 <HTML><HEAD></HEAD><BODY><P><IMG alt="CaptureW.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192063_CaptureW.PNG" style="height: auto;" /></P><P>There is something weird with the <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Calendar Selection Date field.</SPAN></P></BODY></HTML> Wed, 31 Jan 2018 18:49:18 GMT Anonymous 2018-01-31T18:49:18Z Set analysis with calendar https://community.qlik.com/t5/QlikView/Set-analysis-with-calendar/m-p/30548#M458620 <HTML><HEAD></HEAD><BODY><P>Dear all!</P><P>Got simple, but i bit confusing example with some task.</P><P></P><P>I have simple data set with calendar dates and other related field.</P><P>1. I created one text box, which calculates the last previous date (base on selected calendar date in selections), where Calendar Month=1. Calculation is correct</P><P></P><P>2. WHAT I NEED - calculate the second text box with the same logic as in the first, but to show Calendar Selection Date. So if we select 24/04/2017 - expected result is Oct'16.. etc.</P><P></P><P>Thanks in advance for any idea!</P><P>B.G.</P><P>Andrew.</P></BODY></HTML> Wed, 31 Jan 2018 18:38:56 GMT https://community.qlik.com/t5/QlikView/Set-analysis-with-calendar/m-p/30548#M458620 Anonymous 2018-01-31T18:38:56Z Re: Set analysis with calendar https://community.qlik.com/t5/QlikView/Set-analysis-with-calendar/m-p/30549#M458621 <HTML><HEAD></HEAD><BODY><P><IMG alt="CaptureW.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192063_CaptureW.PNG" style="height: auto;" /></P><P>There is something weird with the <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Calendar Selection Date field.</SPAN></P></BODY></HTML> Wed, 31 Jan 2018 18:49:18 GMT https://community.qlik.com/t5/QlikView/Set-analysis-with-calendar/m-p/30549#M458621 Anonymous 2018-01-31T18:49:18Z Re: Set analysis with calendar https://community.qlik.com/t5/QlikView/Set-analysis-with-calendar/m-p/30550#M458622 <HTML><HEAD></HEAD><BODY><P>Nothing weird, i just show last possible date in Date format.</P></BODY></HTML> Wed, 31 Jan 2018 18:57:29 GMT https://community.qlik.com/t5/QlikView/Set-analysis-with-calendar/m-p/30550#M458622 Anonymous 2018-01-31T18:57:29Z Re: Set analysis with calendar https://community.qlik.com/t5/QlikView/Set-analysis-with-calendar/m-p/30551#M458623 <HTML><HEAD></HEAD><BODY><P>Ah ok <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 01 Feb 2018 16:46:34 GMT https://community.qlik.com/t5/QlikView/Set-analysis-with-calendar/m-p/30551#M458623 Anonymous 2018-02-01T16:46:34Z