topic variable analysis on sets in QlikView

variable analysis on sets

warrentk80 — Fri, 29 Apr 2016 08:06:37 GMT

Goodmorning everyone

I need to insert a formula setanalysys an indication of the reference year to take charge.

The field is called year but instead enter the year on the formula

{$ <Year = {'2016'}>}

I would use a var_anno variable set in 2016 and enter into setanalysys the variable.

I tried to insert

{$ <$ Var_anno Year = {}>} but it does not work.

what is the syntax?

Thank you all

Andrew

Anonymous — Fri, 29 Apr 2016 08:09:39 GMT

try

{$ <$Year = {'=$(=Var_anno)'}>}

ajsjoshua — Fri, 29 Apr 2016 08:13:05 GMT

Syntax: <Dimension = {$(NameVariable)} >

Or <Dimension = {$(=NameVariable)} >

(with or without the = sign in front of the variable)

ex:

{<Year={$(var_anno)}>}

Regards,

Joshua.

arasantorule — Fri, 29 Apr 2016 08:30:24 GMT

Hi,

Can you try below.

Year={'=$(Var_anno)'}

Thanks

Kushal_Chawda — Fri, 29 Apr 2016 08:36:23 GMT

try this

{$ <Year = {"$(=Var_anno)"}>}