4 Replies Latest reply: Feb 7, 2017 11:58 PM by Chanin D'Souza RSS

    Current month selection in qlik sense

    Chanin D'Souza

      I would like to know the set analysis expression for the Current Month data. I have created a variable Let vMonth=Month(Today());

      and would like to know if the varibale syntax is correct & if correct, how to use this variable in the Set Analysis Expression, or if an expression can be written without using any variable as well.

      I'm getting stuck with the below syntax. The below syntax when written is not detecting the variable as well. I want the Count of the ATMTakeover for the current month. I don't want to use a filter to get the answer because I want the answer to be dynamic in nature.

      Count({<ATMTakeover_Month={'$(vMonth)'}>}ATMTakeover)

      Where ATMTakeover_Month & ATMTakeover_Date are Field Names.