topic Variable as field name in QlikView

Variable as field name

Thu, 16 Oct 2014 15:21:53 GMT

Hi,

I have the following steps to calculate the total value depending on a currency selection button:

1) A button to select between Local Currency/ Euro. The selection is kept in a variable vCurrency (Values can be LC or EUR)

2) A variable: vCurrencyField to select either the field of LC [Amount LC] or the field with EUR calculations [Amount EUR]. The formula I am using is: =if((vCurrency)='EUR','[Amount EUR]','[Amount LC]')

3) I want to use vCurrencyField in another variable vAmount : sum({<Year={$(vCurrent_Year)},Type={$(vType)}>}$(vCurrencyField))

Unfortunately this does not work. Am I missing any $ or = signs? or what could be the problem?

Best regards,

Re: Variable as field name

m_woolf — Thu, 16 Oct 2014 19:39:35 GMT

2) Field names don't include the square brackets.

Re: Variable as field name

JonnyPoole — Thu, 16 Oct 2014 19:45:46 GMT

i think #2 is wrong too... lose the single quotes

=if((vCurrency)='EUR',[Amount EUR],[Amount LC])

OR #2 is right and you can lose the $() on the vCurrencyField in #3

sum({<Year={$(vCurrent_Year)},Type={$(vType)}>} vCurrencyField )