QlikView App Dev

[Clerwyr]

Hello (sorry for my english),

I made a formule which calculate Sales by PRG, Type and DAT_year.

But I want sales of PRG and Type of the year and previous years. For exemple in DAT_year 2016, i want total sales 2016+2015+2014+...

This formule works, but the year of reference is not variable (2016)... Thanks for your help !

sum(aggr(
Sum(total <PRG,Type> {<DateOperation={"<=$(=makedate(2016,12,31))"}>} Sales)
,PRG,Type,DAT_year))

[sergio0592]

Hi,

Try with :

sum(aggr(
Sum(total <PRG,Type> {<DateOperation={"<=$(=makedate(DAT_year,12,31))"}>} Sales)
,PRG,Type,DAT_year))

[Clerwyr]

Hello Sergio,

It don't works. It give me the max DAT_year...

[adequation_jna]

Hello all,

I'm a colleague of "Clerwyr" , please find attached a POC (.qvf) to resume our issue.

[adequation_jna]