topic Re: set analysis with expression in QlikView

set analysis with expression

souadouert — Fri, 07 Apr 2017 13:03:52 GMT

exp1:

=sum(if(REAL_PACKS.LIB_TYPE_PACK=OBJ_PACK.TYPEPACK and REAL_PACKS.PROD_PACK=1,REAL_PACKS.NOMBRE_PACK))

for exp i want to calculated cumulative Nombre pack, i use this exp

exp2:

=sum({<OBJ_PACK.TYPEPACK={REAL_PACKS.LIB_TYPE_PACK} , REAL_PACKS.PROD_PACK={"1"},YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} ,SITUATION_PRODUIT>} REAL_PACKS.NOMBRE_PACK)

this exp shows 0,

and when i remove OBJ_PACK.TYPEPACK={REAL_PACKS.LIB_TYPE_PACK}

this exp shows result but it's not correct

Re: set analysis with expression

sunny_talwar — Fri, 07 Apr 2017 13:06:01 GMT

What if you do this

=Sum({<REAL_PACKS.PROD_PACK = {1}, YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} , SITUATION_PRODUIT>} If(OBJ_PACK.TYPEPACK = REAL_PACKS.LIB_TYPE_PACK, REAL_PACKS.NOMBRE_PACK))

Re: set analysis with expression

souadouert — Fri, 07 Apr 2017 13:12:48 GMT

hahah thank you sunny