topic How to write a variable into a set expressión in QlikView

How to write a variable into a set expressión

Fri, 12 Oct 2012 18:19:22 GMT

Hi,

I have this variable:

=Avg({1<MER_GRUPO={'A'},DIVISA={'EUR'},c_month={'Oct'},c_year={'2012'}>}I_TME

)

it works OK, but I need that 'Oct' and '2012' were variables too. 'año' is a variable too and I prooved with

=Avg({1<MER_GRUPO={'A'},DIVISA={'EUR'},c_month={'Oct'},c_year={''&año&''}>}I_TME) and similar things but I wasn`t able to get the right results.

How can I do this?

Thanks

Re: How to write a variable into a set expressión

whiteline — Fri, 12 Oct 2012 18:43:15 GMT

Hi.

Depending on what you've stored in a variable (YearVariable for example), you can try on of this:

=Avg({1<MER_GRUPO={'A'},DIVISA={'EUR'},c_month={'Oct'},c_year={'=$(YearVariable)'}>}I_TME)

=Avg({1<MER_GRUPO={'A'},DIVISA={'EUR'},c_month={'Oct'},c_year={'=$(=YearVariable)'}>}I_TME)

Re: How to write a variable into a set expressión

Anonymous — Fri, 12 Oct 2012 18:49:53 GMT

In addition, assuming you need current year and current month, you don't need variables:

=Avg({1<MER_GRUPO={'A'},DIVISA={'EUR'},c_month={"$(=date(ReloadTime(), 'MMM'))"},c_year={"$(=year(ReloadTime()))"}>}I_TME)

Regards,
Michael

Re: How to write a variable into a set expressión

lmenendez_grupo_pinero — Tue, 29 Mar 2022 11:34:54 GMT

This question was made for me in 2012.

How could I recover that user and my own bakground with it?