Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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