topic Problem with set analysis last year in QlikView

Problem with set analysis last year

Wed, 20 Aug 2014 14:22:33 GMT

Hello,

I am trying to put a set analysis last year with to selections and it misses.

Sum ({<Año={$(AñoActual) -1} , Mes={$(MesActual)}>} IMPORTE2)

The actual comma separating Año and Mes (Year and Month) is detected wrong.

Need help is for the job, thank you!

marcus_sommer — Wed, 20 Aug 2014 14:45:54 GMT

It's probably a format-issue. Try something like this:

Mes={'$(MesActual)'} or Mes={$(=num($(MesActual))} or Mes={MesActual}

- Marcus

marthacano01 — Wed, 20 Aug 2014 14:52:35 GMT

Hi Ciro.

Try this:

Sum ({<Año={$(=$(AñoActua) -1)} , Mes={$(MesActual)}>} IMPORTE2)

Thu, 21 Aug 2014 09:21:47 GMT

Works like a charm.

Thank you very much!