Set Analysis Filter

[#1]

Rigth now I'm using a KPI to calculate the Sales Amount for last year and current month like this

SUM({$<Anio={"$(=$(vAnioAnt))"},Mes={"$(=MONTH(TODAY()))"}>}TotalVta)

Where vAnioAnt is a variable containing las year (2014),   but right now I need that the KPI calculate the total sales amount for last year but from January to the current Month.  Please help.  Anio is the field containing the Year, Mes is the field containing Month and TotalVta, is the field containing total sales.

Also I need something alike but calculate the total sales from 1 year from now, for example today form may28, 2014 to may 28, 2015, the field containing date for transaction is fecha.

Thanks in advance

[MK_QSL]

I will provide sample for this.. Kindly change accordingly.

Total Sales For Last Year (Starting From 1st Jan to Today's Date of Last Year

SUM({<Year = {'$(=Year(Today())-1)'}, Month = {"<=$(=Month(Today()))>=$(=Month(YearStart(Today())))"}>}Sales)

2nd Question's answer.

SUM({<Date = {">=$(=(AddYears(Today(),-1)))<=$(=Date(Today()))"}>}Sales)

[#3]

Thank you for your help but both formulas are not working for me

I change the first one for my KPI

SUM({<Anio = {'$(=Year(Today())-1)'}, Mes = {">=$(=Month(YearStart(Today()))<=$(=Month(Today())))"}>}TotalVta)

And the result is 0, and I double check and I had sales in that period.

For the second formula I change it like this:

SUM({<Fecha = {">=$(=(AddYears(Today(),-1)))<=$(=Date(Today()))"}>}TotalVta)

On a Bar Chart but in the bar chart I have columns for years and month before today()-365

What could it be?

[MK_QSL]

Provide sample data or sample application. Will work on this..

[#5]

I have problem with the first KPI, and the Line Chart

The First KPI is the one that must SUM TotalVta, for Anio (Year) = Last Year and Mes (Month) BETWEEN January and Current Month

and the Line Chart must show sells from 12 month from now till now with the field TotalVta (Year field = Anio, Month field = Mes, Date field = fecha)

Thank you in advanced

Claus Fuss

Jefe de Sistemas

El 29/5/2015, a las 13:50, Manish Kachhia <qcwebmaster@qlikview.com> escribió:

Set Analysis Filter

reply from Manish Kachhia <https://community.qlik.com/people/MRKachhiaIMP?et=watches.email.thread> in New to Qlik Sense - View the full discussion <https://community.qlik.com/message/786226?et=watches.email.thread#786226>

Provide sample data or sample application. Will work on this..

Reply to this message by replying to this email, or go to the message on Qlik Community <https://community.qlik.com/message/786226?et=watches.email.thread#786226>

Start a new discussion in New to Qlik Sense by email <mailto:discussions-community-qliksense-newtoqliksense@qliktech-public-v7.hosted.jivesoftware.com> or at Qlik Community <https://community.qlik.com/choose-container.jspa?contentType=1&containerType=14&container=2146&et=watches.email.thread>

Following Set Analysis Filter <https://community.qlik.com/message/786226?et=watches.email.thread#786226> in these streams: Inbox

© 1993-2014 QlikTech International AB | Copyright & Trademarks <http://www.qlikview.com/us/info/copyright> | Privacy <http://www.qlikview.com/us/info/privacy> | Terms of Use <http://www.qlikview.com/us/info/terms-of-use> | Software EULA <http://www.qlikview.com/us/info/software-eula>