Help with Set Analysis filtering dates

[#1]

I need help with this issue I'm having.

First off all lets talk about my data

this are my formats

SET TimeFormat='hh:mm:ss TT';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';

I declare this variables

SET vAnioActual=YEAR(NOW());

SET vAnioAnt=YEAR(NOW())-1;

SET vMesActual=MONTH(Today());

SET vFechaHoy=Now();

SET vFechaAnioAtras = Date#(Now()-365,'DDMMYYYY');

When I bring my data this are my fields that brings date data

LOAD Documento,

    Fecha,

    Date#(Fecha,'DDMMYYYY') As FechaNum,

    YEAR(Fecha) As Anio,

    MONTH(Fecha) As Mes,

     TotalSales............

Where Fecha is my field containing dates in dd/mm/yyyy format

I've been trying to get info of my sales (TotalSales) From the last 12 months from now, I've been trying using, variables, a constant and formulas, but not working at all.    Please help

Thanks in advance

[buzzy996]

try this way,

SUM({<DateDimensionName = {'>=$(=YearStart(Today())) <= $(=Today())'}>} MeasureName)

[#3]

I change the formula you gave me to this

SUM({<Fecha = {'>=$(=YearStart(Today())) <= $(=Today())'}>} TotalVta)

This is the result

[buzzy996]

is't possible to share ur app?

[#5]

Shure

Dropbox - Drocaras.qvf

[#6]

Could you get the App?

[jagan]

HI,

Try like this

SUM({<Anio=,Mes=, FechaNum=, Fecha = {'>=$(=MonthStart(Today(), -11)) <= $(=Today())'}>} TotalSales)

Hope this helps you.

Regards,

Jagan.

[buzzy996]

u mean ur asking to share app for the same from my end?

[#9]

Thanks for the help, but this was the result

This is a link for my app

Dropbox - Drocaras.qvf

[#10]

I mean if you could download my App from the link I publish