topic Sum and IF in QlikView

Sum and IF

Wed, 01 May 2013 14:18:07 GMT

I am using the following as an expression and it is working

Sum({<TERM_CODE_EFF={'2012-13'},REG_STATUS={'RE','RP','RS','WU'},StudyYearCommencementDate={'>01/09/2012''<01/08/2013'},[No Attendance]={'X'}>}Today()-StudyYearCommencementDate)/17

I want to add an IF to the sum statement and have tried a number of different methods but I am not getting nowhere so any help is appreciated.

My IF statement on its own is as follows;

If (LEVEL='PGR',Sum(Today()-StudyYearCommencementDate/41),Sum(Today()-StudyYearCommencementDate/17))

Re: Sum and IF

Gysbert_Wassenaar — Wed, 01 May 2013 14:37:42 GMT

Does this do what you need?

Sum({<TERM_CODE_EFF={'2012-13'},REG_STATUS={'RE','RP','RS','WU'},StudyYearCommencementDate={'>01/09/2012''<01/08/2013'},[No Attendance]={'X'}>}Today()-StudyYearCommencementDate)/if(LEVEL='PGR',41,17)

Re: Sum and IF

Wed, 01 May 2013 14:43:10 GMT

Perfectly thank you