https://community.qlik.com/t5/App-Development/Dimension-range-Today-minus-1-year-in-month-Name/m-p/1773867#M59927 <P>Hello,</P><P>I am currently trying to visualize a stacked bar char with the Date as a dimension. My problem is that I need the dimension to be restricted with today()&nbsp; - 1 year in the date type Monthname(), my actual code seems to work but it doesn't show me the actual month. It only shows the completed months but I need also the actual month even though its not completed yet.</P><P>My Dimension is AW.CanonicalDate</P><LI-CODE lang="markup">=If(MonthName([AW.CanonicalDate]) &gt;= MonthStart(AddYears(Today(), -1)) and MonthName([AW.CanonicalDate]) &lt;= Monthstart(Today()) And MonthName([AW.CanonicalDate]) &lt;= today(), MonthName([AW.CanonicalDate]))</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Oguzhan_0-1610484171483.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46860i269ABD150A78375D/image-size/medium?v=v2&amp;px=400" role="button" title="Oguzhan_0-1610484171483.png" alt="Oguzhan_0-1610484171483.png" /></span></P><P>Can you pleas help me</P> Sat, 16 Nov 2024 00:50:24 GMT Oguzhan 2024-11-16T00:50:24Z https://community.qlik.com/t5/App-Development/Dimension-range-Today-minus-1-year-in-month-Name/m-p/1773867#M59927 <P>Hello,</P><P>I am currently trying to visualize a stacked bar char with the Date as a dimension. My problem is that I need the dimension to be restricted with today()&nbsp; - 1 year in the date type Monthname(), my actual code seems to work but it doesn't show me the actual month. It only shows the completed months but I need also the actual month even though its not completed yet.</P><P>My Dimension is AW.CanonicalDate</P><LI-CODE lang="markup">=If(MonthName([AW.CanonicalDate]) &gt;= MonthStart(AddYears(Today(), -1)) and MonthName([AW.CanonicalDate]) &lt;= Monthstart(Today()) And MonthName([AW.CanonicalDate]) &lt;= today(), MonthName([AW.CanonicalDate]))</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Oguzhan_0-1610484171483.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46860i269ABD150A78375D/image-size/medium?v=v2&amp;px=400" role="button" title="Oguzhan_0-1610484171483.png" alt="Oguzhan_0-1610484171483.png" /></span></P><P>Can you pleas help me</P> Sat, 16 Nov 2024 00:50:24 GMT https://community.qlik.com/t5/App-Development/Dimension-range-Today-minus-1-year-in-month-Name/m-p/1773867#M59927 Oguzhan 2024-11-16T00:50:24Z