Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum all period problem?

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Have you tried

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

?

View solution in original post

2 Replies
swuehl
MVP
MVP

Have you tried

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

?

Not applicable
Author

the only thing i didnt think about.

thank you