5 Replies Latest reply: Jun 14, 2016 5:46 AM by Silambarasan Manickam RSS

    Set Expression not working for Lastmonth value in qlik sense

    Jyoti Ranjan

      Hi my Last month set expression is not working in Qlik sense.

      I have Date fields in source file .from that i got month.

      i have to show This month value and last month value in pivot table.

      sum({<MonthP={$(=Max(MonthP)-1)},DateP=>}MonthlyActual)

       

       

       

      Plz help me.it is urgent.

      Thanks