Variable within a set expression not working

[martin_hamilton]

Hi - I previously posted and gained an answer for only selecting certain values within a straight table. https://community.qlik.com/t5/New-to-QlikView/Only-include-certain-values-in-straight-table/m-p/8267...

I now have a requirement to select based on a variable being included in the set expression.

If i set the expression like the following it works:

=only({<CONNECTED_MONTH={'Nov 2018'}>}CONNECTED_MONTH)

But when I set it like the below it doesnt:

=only({<CONNECTED_MONTH={"=vCurrentMonth"}>}CONNECTED_MONTH)

=only({<CONNECTED_MONTH={"vCurrentMonth"}>}CONNECTED_MONTH)

=only({<CONNECTED_MONTH={vCurrentMonth}>}CONNECTED_MONTH)

The variable is working fine and is the following:

vCurrentMonth is  =MonthName(Today(1))

What am I doing wrong. the field in question it is validating has been derived and shows Nov 2018

Any ideas welcome thank you in advance.

Martin

[phillipmacd · Accepted solution]

hi, maybe try and analyze the value of the variable,

only({<CONNECTED_MONTH={'$(vCurrentMonth)'}>}CONNECTED_MONTH)

[sunny_talwar]

Or one of these

=Only({<CONNECTED_MONTH ={"$(=vCurrentMonth)"}>} CONNECTED_MONTH)
=Only({<CONNECTED_MONTH ={"$(=$(vCurrentMonth))"}>} CONNECTED_MONTH)

[rwunderlich]

Try:

=only({<CONNECTED_MONTH={"$(vCurrentMonth)"}>}CONNECTED_MONTH)

Technically it should be single quotes, but there is a bug in QV 12.20 that requires double quotes when the modifier field is a dual. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com