Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to create a dynamic fieldname in an expression

Hi all,

I want to use a dynamic fieldname in an expression, but I need some help.

In my project I have several fieldnames like:

Ind_AA_Time

Ind_BB_Time

Ind_CC_Time

Ind_DD_Time

The 'AA', 'BB', 'CC' en 'DD' are types of indicators and are stored in a table named 'Indication'.

I want to build the fieldnames dynamicly so I can use them in an expression in a pivot table. So the value of the fieldname is depending on the type of indicator. The indicator is a dimension of the pivot table.

My expression is now like this:

='Ind_'&Indication&'_Time'

It shows the correct fieldname into the column, but not the value of that field.

test.png

How can I build this expression, that it will return the value of the fieldname into the column? I'm sure it will be something silly, but I can't see a solution at this moment.

Thanks in advantage!

4 Replies
jason_michaelid
Honored Contributor II

Re: How to create a dynamic fieldname in an expression

You need to use some dollar-sign expansion to evaluate your input.  Try:

=$(=('Ind_'&Indication&'_Time')) as the dimension (I may not have the syntax exactly right...)

Hope this helps,

Jason

Not applicable

Re: How to create a dynamic fieldname in an expression

Not really, the Indication-part disappears in the string.

I tried everything with the $-sign, but nothing works properly.

To make it easier, I made a litte test-version and added it in my first post.

Re: How to create a dynamic fieldname in an expression

By linking incident name you can get the incident value

Indicator:

LOAD * INLINE [

Indication_name, Value_Ind

    Ind_AA_Time, 11

    Ind_BB_Time, 22

    Ind_CC_Time, 33

    Ind_DD_Time, 44

];

Directory;

LOAD Name,

     Indication,

     Value,

     'Ind_'&Indication&'_Time' AS Indication_name

FROM

test_dynamic_fieldname.qvw.xlsx

//[..\Desktop\Qlikview Project\test\test tussentotaal herbruiken.xlsx]

(ooxml, embedded labels, table is Blad1);

Check the attachment and let me know is this your requirement?

Not applicable

Re: How to create a dynamic fieldname in an expression

Not exactly, I want to use this into a larger expression/formula. Something like this:

IF(Num#(Year)<varLY_BIO,1,(1+IF((varLY_BIO+IND_AA_TIME-Num#(Year))>0,(IND_AA_TIME/100/IND_AA_EXP)*(1+(Num#(Year)-varLY_BIO)),(IND_AA_EXP/100))));

But I didn't made a correct test-version. The version I uploaded now (test_dynamic_fieldname_2), is the correct version.

You will see 4 listboxes where the user can select a value and I want that value into an expression in the pivot table.

Let me know if you need more explanation!

Community Browser