topic Re: Using a string as a fieldname in QlikView

Using a string as a fieldname

rudywelvaert — Tue, 25 Apr 2017 10:04:51 GMT

Hi,

I would like to use a constructed string, for example:

'TID_MONTH_ABR_' & Num(Month(WORK_DATE), '00')

as a field name in a function, for example:

=Only(TID_MONTH_ABR_01)

=Only(TID_MONTH_ABR_02)

...

=Only(TID_MONTH_ABR_12)

Thus:

= Only('TID_MONTH_ABR_' & Num(Month(MONTHDATE), '00'))

I use these TID_ fields in a multilingual environment so the TID-field give me the correct translations in de selected language

So how can I use the string as a field name in a function. Do I put $() or {} or ... around it?

R.W.

Re: Using a string as a fieldname

sunny_talwar — Tue, 25 Apr 2017 11:28:29 GMT

May be with dollar sign expansion

=Only($(='TID_MONTH_ABR_' & Num(Month(MONTHDATE), '00')))

Re: Using a string as a fieldname

did — Thu, 18 Jul 2019 11:24:39 GMT

I'm wondering whether this approach can work for total <field>?

It works fine: if within <> I write MyField , the formula then looks the following way: sum(VALUE) / sum(total <MyField> VALUE)

PROBLEM: MyField variates due to the drilling down, so that it can be MyField1,MyField2,MyField3...

It does not work: if within <> I write MyVariable containing the needed field, the formula then looks the following way: sum(VALUE) / sum(total <vMyVariable> VALUE)

If vMyVariable returns me a string '' which should be interpreted as a field, then according to this post I need something like only($(=$(vMyVariable))) to put it within <> so that my formula looks like: sum(VALUE) / sum(total <only($(=$(vMyVariable))) > VALUE). Unfortunately this does not work for me.

Any ideas/suggestions are very much appreciated.