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 over a condition with valueloop

Hello,

I have been struggeling with the following problem:

I am have to dimensions X et Y. I tried the following with a valueloop function:

Sum(if f(X,Y,Valueloop), Y,0)

When my selection contains more than one X and Y, no data to display.

Can anyone explain to me why

Thank you

3 Replies
giakoum
Partner - Master II
Partner - Master II

So you have 2 dimension fields called X and Y. And if values selected are more than one, show nothing? for example, if X1 and X2 are selected in X, show nothing?

In a chart or?

Not applicable
Author

Yes in a chart, like for Qlikview the condition is false, as he don't associate a specific X and Y o the If

Not applicable
Author

What I want to represent is SUM (if condition (x,y,valueloop), f(x,y),0). Otherwise, for each value of valueloop, we sum the f(x,y) for the couples x,y respecting the condition