Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a "drop down" widget on a report that can take 3 values: "Region", "Office" or "Top25". Whichever is selected is stored in the variable vBaseline.
If I create a "Text and Image" object on my report and use the following expression:
if(vBaseline='A_CON_OT_REGION' or vBaseline='A_CON_OT_OFFICE',
'Region or Office’,
...it behaves as expected: When I change the dropdown object the value returned by the expression is as correct. If, however, I now replace 4th line as per below it misbehaves:
If I select region or office in the drop down then I get the correct value (as calculated by the 4th line). If I select "TOP25", however, I now get a NULL response!!!!
I would love to able to solve this one!