Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Re: aggr() function help

This sounds like set analysis not aggr.

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

View solution in original post

4 Replies
Highlighted
Luminary
Luminary

Re: aggr() function help

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

Re: aggr() function help

This sounds like set analysis not aggr.

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

View solution in original post

Highlighted
Not applicable

Re: aggr() function help

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

You don't use the AGGR()

Highlighted
Not applicable

Re: aggr() function help

Thanks a lot loannis! It works perfectly.

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