Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chanin7893
New 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
Contributor II

Re: Current month selection in qlik sense

vMonth.JPG

Add an equal sign before variable definition, that should work

4 Replies
shubham_singh
Contributor II

Re: Current month selection in qlik sense

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
New Contributor III

Re: Current month selection in qlik sense

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
Contributor II

Re: Current month selection in qlik sense

vMonth.JPG

Add an equal sign before variable definition, that should work

chanin7893
New Contributor III

Re: Current month selection in qlik sense

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