sum previous year sales ignoring month selection QlikView

[carlos_horta1]

Hi,

I have problems with the expression and I need help. I have a straight table where I compare current year/month sales with last year/month.

I select the month and the year and it will show me the sales for the same month in the current and previous year. One of my expression shows me the total sales for last year for each item but i need it to ignore the month selection and that it always shows me the whole previous year.

I am using expression =sum({$(vSETPYTD), <Month=>} Sales) but I get no results. If I only use =sum($(vSETPYTD) Sales) I get the previous year amazon but only for the month that is selected.

How can I ignore the month selection?

[carlos_horta1 · Accepted solution]

I Think I solve it. I use the expression I got when only typing { $<Year={2017},MonthDayNo={"<831"},Month=,[Month Year]=,Quater=,Date=>}, I erase MonthDayNo={"<831"} that was doing some calculation that didn't allow me to get only the whole years sales.

Thank you so much everybody.

[carlos_horta1]

I can not edit the variable.