Set axes in qlikview chart

[Lakshmanan]

Hi , 
I was looking for the possibility to set the axes as month end of the date in Qlikview chart .
something like if Date is 20-Aug -2020 , axes should display 31-Aug-2020 .similar for others to display only monthend date in axes.  In Line chart , if i select dimension axis as continuous , i get the month start for few dates .Can someone please help to get the monthend in axes .

sample axes format to be displayed:

Test file attached .

[rwunderlich]

Change your Dimension expression to:

=Date(Floor(MonthEnd(Date#(InputDate,'DD-MMM-YY'))))

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Lakshmanan]

Hi Rob , 
After updating dimensions ,there comes the Missing months in Axis. 

[rwunderlich]

Uncheck "Suppress Zero Values" in Presentation. 

If you want the line to descend zero in the missing months, you will have to generate 0 values for those months. 

-Rob

[Lakshmanan]

There is no missing months to descend to zero , as you can see in the test file ,there are values for months and those are not displayed in axes or data points in the chart.

[Lakshmanan]

Any suggestions pls

[marcus_sommer]

Check again if there are really fact-records existing for the mentioned months because having those months within a dimension-table isn't sufficient.

[rwunderlich]

Did you try Uncheck "Suppress Zero Values" in Presentation?

-Rob