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?

[andrey_krylov]

Hi, what's the value of this variable vSETPYTD? Or try this

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

[lorenzoconforti]

You had an extra < in your expression. This should work

=sum({$(vSETPYTD), Month=>} Sales)

[andrei_delta]

hi,

since i don't know what your variable value for the vSETPYTD is all i can say is that this expression (sum({$(vSETPYTD), <Month=>} Sales) ) has syntax problems...

the correct syntax is sum({<Month=,$(vSETPYTD)>} Sales)

hope it helps,

Andrei

[lorenzoconforti]

It actually looks like you have angle brackets in your variable

You can remove the angle brackets from the variable and then write your expression like this:

=sum({<$(vSETPYTD), Month=>} Sales)

Or you can leave them in your variable and rewrite the expression using the intersection operator:

=sum({$(vSETPYTD) * <Month=>} Sales)

[carlos_horta1]

Tbh, I am not sure since I'm taking the program from someone else and I don't have access to the script or I don't know to to get there. It helps me get the previous year data (Sales, quantity, etc). When I type $(vSETPYTD) as an expression on my straight table I get this expression when I select year 2018 and month Aug:

{ $<Year={2017},MonthDayNo={"<831"},Month=,[Month Year]=,Quater=,Date=>}

[carlos_horta1]

I tried and it didn't work. I don't know why

[carlos_horta1]

Thanks Andrei. I tried it and it didn't work. vSETPYTD helps me getting the previous Years to Day values.

When I type $(vSETPYTD) as an expression on my straight table I get this expression when I select year 2018 and month Aug:

{ $<Year={2017},MonthDayNo={"<831"},Month=,[Month Year]=,Quater=,Date=>}

[carlos_horta1]

I tried both and none of them worked

[andrei_delta]

so if you want to use the expression you will write it like sum ( $(vSETPYTD )  Sales ) and can you edit the variable?