Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
saggroad
Partner - Contributor
Partner - Contributor

AGGR with additional dimension

Hi

In the below aggregation which works well  I also want to add only 'NEW' products (TYPE = "NEW').

Could someone tell me how would I include also TYPE = 'NEW' in the below aggregation so that it only sums up 'NEW'

 

=-

sum(aggr(distinct only(INFPERIOD)='$(vInforceMonth0)',Value))

Thank you!

0 Replies