Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Yes in a chart, like for Qlikview the condition is false, as he don't associate a specific X and Y o the If
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