
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Current month selection in qlik sense
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Your Syntax is correct, the only possible reason that this would not work is mismatch in format of variable and field.
Create a list of ATMTakeover_Month and post them here.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm attaching the image below Which contain the fields of ATMtakeover. I just want the selection of the current month, i.e. Feb 2017

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add an equal sign before variable definition, that should work

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it worked but the variable had to put in "Double Quotes". I had put it in single quotes. so i was not functioning
