topic Re: Total sales in a year and before in QlikView

Total sales in a year and before

Clerwyr — Wed, 06 Mar 2019 17:20:28 GMT

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 — Wed, 06 Mar 2019 18:53:08 GMT

Hi,

Try with :

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

Clerwyr — Thu, 07 Mar 2019 08:06:34 GMT

Hello Sergio,

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

adequation_jna — Thu, 07 Mar 2019 08:30:42 GMT

Hello all,

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

adequation_jna — Thu, 07 Mar 2019 08:31:44 GMT