Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to using the aggr() function, but I think it can help me.
I am trying to come up with the sum(BO) but only for when XSTOCK=S and XSTOCK=N. I attatched a picture of what im working on.
Do you guys have any ideas for an expression that will work?
Thanks,
Chase
This sounds like set analysis not aggr.
sum({$<[XSTOCK]={"S, N"}>} [BO])
Should be:
=sum(if(XSTOCK='S' and XSTOCK='N',BO) based on your question but that won't work so try replacing 'and' with 'or'.
Hope that helps,
Matt - Visual Analytics Ltd
Qlikview Design Blog: http://QVDesign.wordpress.com
@QlikviewBI
This sounds like set analysis not aggr.
sum({$<[XSTOCK]={"S, N"}>} [BO])
somma ($ {<[XSTOCK] = {"S, N"}>} [BO]) or Sum (if (XSTOCK = 'S' and XSTOCK = 'N', BO),.
You don't use the AGGR()
Thanks a lot loannis! It works perfectly.
I'll have to look into set analysis a bit more..