Help with Set Analysis

Wed, 23 Nov 2011 09:54:03 GMT

Hi,

I have the following expressions contained in variables, extracted just for help purposes.

This calculates a value for each month but I need this to calculate a value for 3 months prior, i.e. If I select 201110, it must give me the value 201107 using set analysis.

"Period" is the date (Year/Month) field we are using.

The variable for 3 months prior's date is v3MonthsAgo.

=sum(aggr(if((sum(
(
((( (
           if(F_TRNS_AMT <= TOBR_LOW_CASH_VALUE_LEVEL , TOBR_Low_CASH_Factor ,TOBR_Ideal_CASH_Factor ) *     F_CASH_TOBR_Units
     )
     +
     F_TOBR_Units) * TOBR_Unit_Reward ) * IF ( Accuracy_Amount_pm >= AccF_Step1_FROM AND   Accuracy_Amount_pm < AccF_Step2_FROM        ,        AccF_Step1_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step2_FROM AND   Accuracy_Amount_pm < AccF_Step3_FROM        ,        AccF_Step2_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step3_FROM AND   Accuracy_Amount_pm < AccF_Step4_FROM        ,        AccF_Step3_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step4_FROM AND   Accuracy_Amount_pm < AccF_Step5_FROM        ,        AccF_Step4_FACTOR        ,
     AccF_Step5_FACTOR        )))))
-
( Accuracy_Amount * AccFactorRATE)

) ) +(sum( - AccFactorRATE * Accuracy_Amount ) ) )<0,0,(sum(
(
((( (
           if(F_TRNS_AMT <= TOBR_LOW_CASH_VALUE_LEVEL , TOBR_Low_CASH_Factor ,TOBR_Ideal_CASH_Factor ) *     F_CASH_TOBR_Units
     )
     +
     F_TOBR_Units) * TOBR_Unit_Reward ) * IF ( Accuracy_Amount_pm >= AccF_Step1_FROM AND   Accuracy_Amount_pm < AccF_Step2_FROM        ,        AccF_Step1_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step2_FROM AND   Accuracy_Amount_pm < AccF_Step3_FROM        ,        AccF_Step2_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step3_FROM AND   Accuracy_Amount_pm < AccF_Step4_FROM        ,        AccF_Step3_FACTOR        ,IF ( Accuracy_Amount_pm >= AccF_Step4_FROM AND   Accuracy_Amount_pm < AccF_Step5_FROM        ,        AccF_Step4_FACTOR        ,
     AccF_Step5_FACTOR        )))))
-
( Accuracy_Amount * AccFactorRATE)

) ) +(sum( - AccFactorRATE * Accuracy_Amount ) ) )),EmpNumber_sPeriod))

topic Help with Set Analysis in QlikView

Help with Set Analysis