topic Problem after modifying the expression in QlikView

Problem after modifying the expression

Anonymous — Mon, 29 Apr 2013 09:31:04 GMT

Hi ,

I have an expression like this,

= SUM({

$<

ACCT_MO = P({$}MO),

ACCT_WK_IN_YR = P({$}WK_IN_YR),

ACCT_YR = {$(=only(YR))},

MO_NM_ABBR =

>}NET_LBS_SHIPPED)

/

SUM({

$<

SLR_PCT_RANGE = ,

ACCT_MO = P({$}MO),

ACCT_WK_IN_YR = P({$}WK_IN_YR),

ACCT_YR = {$(=only(YR))},

MO_NM_ABBR =

>}

TOTAL <$(eCycleGroup)> NET_LBS_SHIPPED)

I modified my expression to,

= SUM({

$<

ACCT_MO = P({$}ACCT_MO),

ACCT_WK_IN_YR = P({$}ACCT_WK_IN_YR),

ACCT_YR = {$(=only(ACCT_YR))},

ACCT_MO_NM_ABBR =

>}NET_LBS_SHIPPED)

/

SUM({

$<

SLR_PCT_RANGE = ,

ACCT_MO = P({$}ACCT_MO),

ACCT_WK_IN_YR = P({$}ACCT_WK_IN_YR),

ACCT_YR = {$(=only(ACCT_YR))},

ACCT_MO_NM_ABBR =

>}

TOTAL <$(eCycleGroup)> NET_LBS_SHIPPED)

After modifying the expression, in the front end chart i have a cyclic group. The values which are NULL are not displaying with Dimensions.