Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr() function help

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

This sounds like set analysis not aggr.

sum({$<[XSTOCK]={"S, N"}>} [BO])

View solution in original post

4 Replies
Highlighted
Luminary
Luminary

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

Highlighted
Partner
Partner

This sounds like set analysis not aggr.

sum({$<[XSTOCK]={"S, N"}>} [BO])

View solution in original post

Highlighted
Not applicable

somma ($ {<[XSTOCK] = {"S, N"}>} [BO])   or  Sum (if (XSTOCK = 'S' and XSTOCK = 'N', BO),.

You don't use the AGGR()

Highlighted
Not applicable

Thanks a lot loannis! It works perfectly.

I'll have to look into set analysis a bit more..