topic Re: expression without dimension in QlikView

expression without dimension

souadouert — Tue, 02 May 2017 20:43:16 GMT

I have a table with the expression test1 and test:

TEST1:

if((sum({<REAL_PACKS.LIB_TYPE_PACK={"SAFIR PRO","ELITE (ex PREMIUM)","PLATINUM","SAFIR","ELITE PRO","PLATINUM PRO"},REAL_PACKS.PROD_PACK={"1"}>}REAL_PACKS.NOMBRE_PACK)

(sum({<ANNEE_OBJECTIF={$(=Max(YEAR))},MARCHE_OBJECTIF={"PP"},OBJ_PACK.TYPEPACK={"ELITE","PLATINUM","SAFIR","SAFIR PRO"}>}OBJ_PACK.PACK_OBJ/100*60)/6*MAX(MONTHNUM)))*100>200

,2,

sum({<REAL_PACKS.LIB_TYPE_PACK={"SAFIR PRO","ELITE (ex PREMIUM)","PLATINUM","SAFIR","ELITE PRO","PLATINUM PRO"},REAL_PACKS.PROD_PACK={"1"}>}REAL_PACKS.NOMBRE_PACK)

(sum({<ANNEE_OBJECTIF={$(=Max(YEAR))},MARCHE_OBJECTIF={"PP"},OBJ_PACK.TYPEPACK={"ELITE","PLATINUM","SAFIR","SAFIR PRO"}>}OBJ_PACK.PACK_OBJ/100*60)/6*MAX(MONTHNUM))

)

TEST:

I WANT TEST ELIMINATES THE DIMENSION AGENCY IS TO SAY POSSIBLE EXPRESSION OF ALL AGENCIES

Re: expression without dimension

rwunderlich — Tue, 02 May 2017 21:21:15 GMT

Just remove the Dimension from your chart?

-Rob

Re: expression without dimension

souadouert — Tue, 02 May 2017 21:37:36 GMT

hahah ROB and test1 ??

Re: expression without dimension

rwunderlich — Tue, 02 May 2017 21:55:35 GMT

Ok, I understand.

Use the TOTAL keyword within the aggregation functions of TEST (Sum & Max) to ignore dimensions.

-Rob

Re: expression without dimension

souadouert — Wed, 03 May 2017 07:39:03 GMT

I apologize rob I am beginner, you can better explain, i dont know key word TOTAL

Re: expression without dimension

tresB — Wed, 03 May 2017 07:44:08 GMT

Have a look here: What does the TOTAL qualifier do?

Re: expression without dimension

souadouert — Wed, 03 May 2017 08:33:57 GMT

ROB thank y very much i resolved with TOTAL

Re: expression without dimension

rwunderlich — Wed, 03 May 2017 11:30:31 GMT

The Help function in QlikView has some good examples of TOTAL as well.

-Rob