Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
lblumenfeld
Contributor II

How do I access the field name for a field in a MutiBox

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!

4 Replies

Re: How do I access the field name for a field in a MutiBox

May be this:

=If(SomeValue = $(=Chr(39) & DynamicField & Chr(39)), ThisValue, OtherValue)

Only one selection in DynamicField will work here.

lblumenfeld
Contributor II

Re: How do I access the field name for a field in a MutiBox

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.

MVP & Luminary
MVP & Luminary

Re: How do I access the field name for a field in a MutiBox

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

lblumenfeld
Contributor II

Re: How do I access the field name for a field in a MutiBox

I was pretty sure that was the case. Thanks for confirming it, Rob.‌