Tuning the Expression

Fri, 29 Jun 2012 19:30:22 GMT

Hi,

Is there a way to tune the below expression,My expression should only return value if sum>'0'.Please let me know your thoughts.

=sum(aggr(

if(sum ({$<CALENDAR_DATE={'>=$(=Date(VSTARTDATE))<=$(=Date(VENDDATE))'},GC_BUY_OR_REDEEM={'B'},

STORE_BH={'0'},STORE_CA={'0'},STORE_GCPO={'0'},STORE_TP={'0'}>} GC_BALANCE)-(0-(sum ({$<REDEMPTION_DATE={'>=$(=Date(VSTARTDATE))<=$(=Date(VENDDATE))'},GC_BUY_OR_REDEEM={'B'},

GC_BUY_OR_REDEEM_R-={'B'},GC_CARD_NUMBER-={'6098800000740686'},

STORE_BH={'0'},STORE_TP={'0'},STORE_CA={'0'},STORE_GCPO={'0'}>} REDEMPTION_AMOUNT)))<'0',

'0',

sum ({$<CALENDAR_DATE={'>=$(=Date(VSTARTDATE))<=$(=Date(VENDDATE))'},GC_BUY_OR_REDEEM={'B'},

STORE_BH={'0'},STORE_CA={'0'},STORE_GCPO={'0'},STORE_TP={'0'}>} GC_BALANCE)-(0-(sum ({$<REDEMPTION_DATE={'>=$(=Date(VSTARTDATE))<=$(=Date(VENDDATE))'},GC_BUY_OR_REDEEM={'B'},

GC_BUY_OR_REDEEM_R-={'B'},GC_CARD_NUMBER-={'6098800000740686'},

STORE_BH={'0'},STORE_TP={'0'},STORE_CA={'0'},STORE_GCPO={'0'}>} REDEMPTION_AMOUNT)))),GC_CARD_NUMBER))

Thanks,

Swetha

topic Tuning the Expression in QlikView

Tuning the Expression