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]

i'm unable to download ur file.

[#3]

How can I sent you the App?

[buzzy996]

clik on reply--from top right side --clik on Use advanced editor--from right side bottom --clik on attach--browser ur .qvw file and save

[#5]

Here it is, thanks for the help

[buzzy996]

ur file extension is .qvf. so i'm unable to open..can u share .qvw file...pls?

are u tried jagan mohan solution?

[#7]

Yeap, didn't work neither

I have Qlik Sense I don't know how to transform it as .qvw  sorry

[buzzy996]

ohh..is't,sorry the solution we given hopes work on qlikview..might be little bit different in qliksense.

u can post this query on qliksnes,by select tag as qliksense instead of qlikview,right now this thread on qlikview group.

[#9]

sorry my bad, I'm new on this, thank you very mucho for your help

[buzzy996]

ur wc ,hope u will get answer from qliksense group.

[santhoo_san]

Hi Try this

SUM( {<Fecha = {">=$(=Min({<Anio={$(=max(Anio))}>}  Fecha))"}>} TotalVta)