Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

two conditions in one sum dimention

Hi

Tell me please who know, can i use something like this:

Aggr(sum({<year={"2012"},id=>} sum({<bg_t={'*'},id=>} Quantity_i)),AffiliateID, Id,mes)

in field whith expression i need to sum Quantity_i by 2 conditions:

1. Only 2012 by year

2. Only bg_t that is not null

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: two conditions in one sum dimention

Hi,

Try this expression

Aggr(sum({<year={"2012"}, bg_t={'*'},id=>} Quantity_i),AffiliateID, Id,mes)

Regards,

Jagan.

2 Replies
MVP & Luminary
MVP & Luminary

Re: two conditions in one sum dimention

Hi,

Try this expression

Aggr(sum({<year={"2012"}, bg_t={'*'},id=>} Quantity_i),AffiliateID, Id,mes)

Regards,

Jagan.

Not applicable

Re: two conditions in one sum dimention

thank you very-very much !

Community Browser