Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ok, I understand.
Use the TOTAL keyword within the aggregation functions of TEST (Sum & Max) to ignore dimensions.
-Rob
Just remove the Dimension from your chart?
-Rob
hahah ROB and test1 ??
Ok, I understand.
Use the TOTAL keyword within the aggregation functions of TEST (Sum & Max) to ignore dimensions.
-Rob
I apologize rob I am beginner, you can better explain, i dont know key word TOTAL
Have a look here: What does the TOTAL qualifier do?
ROB thank y very much i resolved with TOTAL
The Help function in QlikView has some good examples of TOTAL as well.
-Rob