Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expression

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

Regards,

Jagan.

View solution in original post

2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expression

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

Regards,

Jagan.

Not applicable
Author

thank you very-very much !