1 Reply Latest reply: Apr 11, 2017 9:27 AM by Ivan FELIPE ASENSIO RSS

    QlikSense - Possiblity of on Open Action trigger or its alternative

    Praveena Kumar

      Hi All,

       

      In a QlikSense Dashboard,

      I had the KPIs showing data of current Month(April,2017) by default on opening the report and when a selection is made on Month and Year concatenated filter, the data shows accordingly to the selection (after opening the report).

      My Currently used expression is,

      sum({<[MID] = {10},MonthAndYear=,MDate={'>=$(=Date(MonthStart(Max(MDate)),'MMM|DD|YYYY'))<=$(=Date(MonthEnd(Max(MDate)),'MMM|DD|YYYY'))'}>}value)

       

      As a new interest, how can I show Prior one month (March,2017 if current month is April,2017) by DEFAULT on opening the report, but show data accordingly to the selected filter (like Feb,2017 selection shows Data of Feb,2017, Apr,2017 selection shows data of Apr,2017, and likewise...)

       

       

      Thanks,

      Praveena Kumar