topic Re: Help in set_analisys formula in QlikView

Help in set_analisys formula

gamaplast — Sat, 03 Jan 2015 16:42:29 GMT

Hi,

I have to build an expression in set_analisys which sums the values of a reference year from Jan to a reference month; reference year and reference month are stored in two variables.

It should be something like that:

=Sum( {$<AnnoReg = {$(RefYear)}, MeseRegNum = {"=<$(RefMonth)"}>} Values)

Should someone help me with the syntax formula, please?

Thks.

Re: Help in set_analisys formula

Colin-Albert — Sat, 03 Jan 2015 16:55:34 GMT

Try this

=Sum( {$ <AnnoReg = {$(RefYear)}, MeseRegNum = {"<=$(RefMonth)"}>} Values)

Re: Help in set_analisys formula

gamaplast — Sat, 03 Jan 2015 17:03:56 GMT

Thank you, Albert,

it was only a little (but very important) switch!! 😉

C u soon for next help... 🙂