Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello again,
Can anyone recommend a good place to look over syntax rules and examples for expressions?
In particular I'm looking for help for taking the average of a value when it's value is greater than zero.
Thanks
Help menu and the reference manual in the QlikView\Documentation directory, I'd say.
For this specific problem, probably avg({<Value={">0"}>} Value).
Help menu and the reference manual in the QlikView\Documentation directory, I'd say.
For this specific problem, probably avg({<Value={">0"}>} Value).