https://community.qlik.com/t5/QlikView/Set-Analysis-and-Set-Expression-actual-month/m-p/1676717#M727489 <P>Works as joy - many thanks</P> Tue, 18 Feb 2020 14:57:04 GMT fhinland_1 2020-02-18T14:57:04Z https://community.qlik.com/t5/QlikView/Set-Analysis-and-Set-Expression-actual-month/m-p/1675683#M727487 <P>I've created a dashboard with daily-values. I used a trigger, when the .qvw opens select Date as follows&nbsp;</P><P>&nbsp;</P><P>firstworkdate(today(),3, $(vFeiertage))</P><P>&nbsp;</P><P>I also want to show cumulated values, in this example the sales. If the formula above returns a date like 12.02.2020 i need to get 01.02.2020 till 12.02.2020 in my set expressions/analysis.&nbsp;</P><P>&nbsp;</P><P>But how to?</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Set-Expression-actual-month/m-p/1675683#M727487 fhinland_1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Set-Analysis-and-Set-Expression-actual-month/m-p/1675701#M727488 <P>You can try using MonthStart() like:</P><P>"&gt;=<STRONG>MonthStart</STRONG>(<SPAN>firstworkdate(today(),3, $(vFeiertage))</SPAN>)&nbsp; &nbsp;&lt;=<SPAN>firstworkdate(today(),3, $(vFeiertage)) "</SPAN></P> Fri, 14 Feb 2020 09:25:35 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Set-Expression-actual-month/m-p/1675701#M727488 tresB 2020-02-14T09:25:35Z https://community.qlik.com/t5/QlikView/Set-Analysis-and-Set-Expression-actual-month/m-p/1676717#M727489 <P>Works as joy - many thanks</P> Tue, 18 Feb 2020 14:57:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Set-Expression-actual-month/m-p/1676717#M727489 fhinland_1 2020-02-18T14:57:04Z