topic Re: Special variable concatenation. in QlikView

Special variable concatenation.

Thu, 30 Jan 2014 18:59:49 GMT

Hi, everyone. Hope you are doing good. My problem is the following:

I have a variable called 'v_SelectedMonth' (if the selected month is 'Jan', the variable adopts 'January'; if the selected value is 'Feb', the variable adopts 'February'. You get the point).

Now, separately, I have twelve variables: v_DolarCotizationJanuary, v_DolarCotizationFebruary... etc.

And I need to do a division: the divisor is one of those twelve values, depending on the selected month: so, if I select 'Nov', I want 'v_DolarCotizationNovember' to be my divisor, and I want to achieve that value through the concatenation of 'v_DolarCotization' and the content of v_SelectedMonth. I need to do something like this

Amount / if(Moneda='Peso',1,$('v_DolarCotization' & $(v_SelectedMonth)) ) * (-1)

Of course, I am here because that doesn't work.

Does anyone know how can I achieve this?

Thank you very much!

Re: Special variable concatenation.

Gysbert_Wassenaar — Thu, 30 Jan 2014 19:09:13 GMT

Perhaps this: $(='v_DolarCotization' & $(v_SelectedMonth))

Re: Special variable concatenation.

Thu, 30 Jan 2014 19:20:22 GMT

Good one, Gysbert. But sadly, it did not work for me : (

Re: Special variable concatenation.

jerem1234 — Thu, 30 Jan 2014 19:52:37 GMT

Maybe:

$(='v_DolarCotization' & v_SelectedMonth)

Re: Special variable concatenation.

Fri, 31 Jan 2014 12:36:25 GMT

Yeah! You nailed it, jerem1234! Thank you very much!