Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
chanin7893
Partner - Contributor III
Partner - Contributor III

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.

1 Solution

Accepted Solutions
shubham_singh
Partner - Creator II
Partner - Creator II

vMonth.JPG

Add an equal sign before variable definition, that should work

View solution in original post

4 Replies
shubham_singh
Partner - Creator II
Partner - Creator II

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.

chanin7893
Partner - Contributor III
Partner - Contributor III
Author

I'm attaching the image below Which contain the fields of ATMtakeover. I just want the selection of the current month, i.e. Feb 2017ATMTakeoverimage.png

shubham_singh
Partner - Creator II
Partner - Creator II

vMonth.JPG

Add an equal sign before variable definition, that should work

chanin7893
Partner - Contributor III
Partner - Contributor III
Author

it worked but the variable had to put in "Double Quotes". I had put it in single quotes. so i was not functioning