Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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..