topic Dimensions in QlikView

Dimensions

Mon, 26 Jan 2026 18:19:17 GMT

Hello

I have two dimensions

BMI YEAR

BMI WEEKNR

Expression sum(sales).

So when i select in box year 2014 i see the sum(sales) for each week.

I have a slider based on KPI Bruto (-10% , -5%, 0%, 5%, 10%)

Now i am looking for the formula that

shows the selected sum(sales) for the selected year minus 1 and then multiplied by the KPI Bruto.

Example

Week 10 Year selected 2014, sum(bruto) 100 shows point 100 for weeknr 10

other value should be sum(bruto) for week 10 for year 2013 multiplied by KPI Bruto

Please help me with the formula.

sebastiandperei — Wed, 17 Dec 2014 20:33:11 GMT

sum ({<Year_field={$(=Max(Year_field)-1)}>} sales) * KPI_bruto_variable

Wed, 17 Dec 2014 20:50:46 GMT

You must know

Y Ax is: BRUTO amount number

x As is: weeknr (1 to 52)

Wed, 17 Dec 2014 21:01:12 GMT

FORMULA: should be the bruto sum of the weeknr of the year before the selected year.

sebastiandperei — Wed, 17 Dec 2014 22:39:00 GMT

Send the reduced .qvw copy please, i cant understand why last comment didn't work.

Fri, 19 Dec 2014 19:24:46 GMT

i think it's a mix between number variables and alfanumeric values in database?!