Problems showing Prev month sales.

[menazzit]

Hi.

I'm new in Qlik sense.

I need to show this

	2018-01	Previus Month	Forecast
Admin	30	25	32
Seller 1	33	40	45
Seller 2	43	35	40

I use Sql server Via Oledb, I have Date, Year, Month and cuantity fields in my query.

I try defining variables on the script section and use a measure

The variables have allredy been Checked.

Sum({<Year={"$(=Max(Year))"}, YearMonth={"<=$(=vPriorMonthYear)"}, Year=,Month=>}Cuantity)

On a pivot Table. But I always recieve the same values on "2018-01" and Previus Month columns.

[sunny_talwar]

Why are you using <= vPriorMonthYear, do you need all years summed together or just the last month? Also, for 201801, the last Month will be in Year 2017. You might want to consider removing the set analysis from Year field because that is contradicting your YearMonth's set analysis.