Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi, maybe try and analyze the value of the variable,
only({<CONNECTED_MONTH={'$(vCurrentMonth)'}>}CONNECTED_MONTH)
hi, maybe try and analyze the value of the variable,
only({<CONNECTED_MONTH={'$(vCurrentMonth)'}>}CONNECTED_MONTH)
Or one of these
=Only({<CONNECTED_MONTH ={"$(=vCurrentMonth)"}>} CONNECTED_MONTH) =Only({<CONNECTED_MONTH ={"$(=$(vCurrentMonth))"}>} CONNECTED_MONTH)
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