topic Re: Variable within a set expression not working in QlikView

Variable within a set expression not working

martin_hamilton — Sat, 16 Nov 2024 05:06:12 GMT

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 — Thu, 29 Nov 2018 13:23:14 GMT

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

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

sunny_talwar — Thu, 29 Nov 2018 13:29:16 GMT

Or one of these

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

rwunderlich — Thu, 29 Nov 2018 13:29:42 GMT

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.