6 Replies Latest reply: Apr 21, 2017 6:49 AM by omar bensalem RSS

    expression not working in sense

    Martin Hamilton

      Hi - I am looking to port from qlikview to qliksense but a formula doesnt seem to be working.

       

      I have a variable contained within the expression:

       

      vCurrentMonth which has the following expression : MonthName(Today(1))

       

      I have inserted the expression within a text box and its working as expected but within the following its not pulling the relevant data.

       

      Sum({<Invoice_Month={'$(vCurrentMonth)'}>}Subs_Invoice_Amount)

       

      The expression is working in qlikview but not sense.

       

      thanks

       

      Martin