Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

vMonth.JPG

Add an equal sign before variable definition, that should work

View solution in original post

4 Replies
Highlighted
Partner
Partner

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.

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

vMonth.JPG

Add an equal sign before variable definition, that should work

View solution in original post

Highlighted
Partner
Partner

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