sum all period problem?

Tue, 27 Mar 2012 12:49:27 GMT

hi all,

i have a problem with calculation with condition.

i have a chart that in one column i want him to calculate all time WITHDRAWS no matter what the dates i choose.

the problem is that i have condition to this dimension:(exp)

sum({$<WD_GROUP={'Approved Client Withdraw'}>}WITHDRAWS)

usually when i want to do this i write this format:

sum({<YYYY=,MM=,DD=>} WITHDRAWS)

but when there is condition this action is not working.

i tried to write this but without success:(exp)

sum({$<WD_GROUP={'Approved Client Withdraw'}>}WITHDRAWS) and sum({<YYYY=,MM=,DD=>} WITHDRAWS)

does anyone have idea?

thank you

eran

swuehl — Tue, 27 Mar 2012 12:59:02 GMT

Have you tried

sum({$<WD_GROUP={'Approved Client Withdraw'}, YYYY=,MM=,DD= >} WITHDRAWS)

Tue, 27 Mar 2012 13:22:43 GMT

the only thing i didnt think about.

thank you

topic sum all period problem? in QlikView