This content has been marked as final.
Show 3 replies

Re: Sums in Pivot table with If formula
Sunny Talwar Jan 30, 2018 11:40 AM (in response to Benjamin Buth)See here
Sum of rows in pivot tables ‒ QlikView
In short you need to use
Sum(Aggr(YourExpressionHere, YourDimension/s))

Re: Sums in Pivot table with If formula
Benjamin Buth Jan 31, 2018 2:17 AM (in response to Sunny Talwar )Hi,
sounds good, but I get always a mistake in the formula:
sum(aggr({$<Country__c={Germany},Status={qualified},IsConverted={0},IsDeleted={0},Business_Type__c={"Doors","VA Repairs"},[Lead.LeadSource]={"Other","Initiated: Prospecting"},OldValue={"qualified"}>}[LeadHistory.CreatedDate.autoCalendar.Date]))
Seems like there something missing, but I don´t know what...

Re: Sums in Pivot table with If formula
Sunny Talwar Jan 31, 2018 7:23 AM (in response to Benjamin Buth)This was your measure or dimension?

