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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.