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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

AGGR problem

Need a little help with this.  What am I missing?  Trying to get the average number of days it takes to win a quote.  Them compare it to the overall company. Thanks Avg({} total aggr(sum({} Num_ApptSchEnd_Date) -                       aggr(sum({} Num_Opportunity_Created_On) /                         count({}DISTINCT(ProposalNo),L3Desc)

1 Reply
JonnyPoole
Former Employee
Former Employee

There are syntax errors in the expression you posted but i couldn't tell you what the right expression is without some kind of test data or qvw to work with.