Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
adequation_jna
New Contributor II

Total sales before an "end-period" about "actif programs"

Hello all,

Our need is below  :

- #01 :  identify all couple "program / type" actif in a period. Actif significated, having unless one sale in the year.

- #02 : for each couple "program / type" we have to sum all sales about this couple "program / type"  before the end of the current period ( sales performed during the current year and during previous years)

 

static formule(OK) :

sum(aggr(
Sum(total <Program,Type> {<Date={"<=$(=makedate(2015,12,31))"}>} Sales)
,Program,Type,Year))

dynamic formule(KO) :

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

We have no issue to do this calcul for a fixed year, but when we tru to do this for a year given in dimension we are facing an issue (we think is due to the total)

 

Thx for you times ,

 

 

 

POC_Formule_TauxEcoulement.png

Tags (2)
Labels (3)
1 Reply
adequation_jna
New Contributor II

Re: Total sales before an "end-period" about "actif programs"

// Ko dynamique
sum(aggr(
Sum(total <Program,Type> {<Date={"<=$(=makedate(""Year"",12,31))"}>} Sales)
,Program,Type,Year))

 

sorry for copy/paste issue : Year is the field and not DAT_Year!!!

 

_correctionPOC_Formule_TauxEcoulement.png