Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Suppose I have a MultiBox with field Company, State, Product, Department.
I'd like to use a formula in the label, which will need to know the field name. For simplicity let's suppose the formula is:
Label:
=If(SomeValue = "Company", ThisValue, OtherValue)
I'd like to substitute "Company" with the name of the field. So, in other words, dynamic, rather than hard-coded.
How do I access the name of the field that this label is for?
Thanks!
May be this:
=If(SomeValue = $(=Chr(39) & DynamicField & Chr(39)), ThisValue, OtherValue)
Only one selection in DynamicField will work here.
This will only work if I've set DynamicField = to the value "Company". My question is, how do I reference the name of this specific field in the multibox
In other words ... I'd like to past this formula in the label box for every field in the multibox and have it resolve to the correct value for each field.
Somewhat of a WhatIsThisCurrentField function.
QlikView expression doesn't have a "This" reference. I'm afraid there is no way for the label expression to dynamically reference what field it belongs to.
-Rob
I was pretty sure that was the case. Thanks for confirming it, Rob.