Help in set analysis current selection and last year (with current selection)

ali_hijazi — Fri, 11 Aug 2017 13:26:49 GMT

Hello in attached qvw file

I got w variables:

vBudget_Forecast

and

vBudget_Forecast_LY

the first variable is intended to calculate the the Forecast in selection and is giving correct result

the second variable is intended to calculate the forecast for previous year (while selecting current year)

vBudget_Forecast (2016) is giving a value that is different from vBudget_Forecast_LY for(2017)

the first variable is as follows:

sum

(

aggr

(

isnull($(vAvg_Selling_Price_KG))

$(vAvg_Selling_Price_KG)< 0.5 * $(vPriceList_KG)

$(vAvg_Selling_Price_KG)> 1.5 * $(vPriceList_KG)

$(vPriceList_KG)

$(vAvg_Selling_Price_KG)

)

$(vSalesQty_Forecast_KG)

,account_company_key,MONTH_YEAR,customer_key,product_key,account_row_id

)

for the second variable I created variables with the same name but added _LY (last year)
the problem is in the vPriceList_KG and vPriceList_KG_LY I'm assuming

cause the other variables are giving correct result when switching between Years in selection

Please advise

this is urgent for me

topic Help in set analysis current selection and last year (with current selection) in QlikView

Help in set analysis current selection and last year (with current selection)