7 Replies Latest reply: Aug 19, 2015 9:37 AM by Jonathan Dienst RSS

    Display Message when no data is selected (YTD)

    Philipp Schöck

      Hi all,

       

      I have a table with an YTD (year to date) expression. This works greate.

      But I want to show a message if no date is slected, because in this case the table is empty.

       

      At the moment i use this for calculating my ytd:

       

      sum({<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} AmountofOrder)

       

      If no date is selected it looks like this:

       

      2015-08-19_14h43_01.png

      In this Case I want to display the Message "Please select a Year and Month"

       

      2015-08-19_14h47_37.png

       

      How could I do that?

       

      Many Thanks for your efforts.

       

      Philipp