Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm creating a script and want to do the average days between enquiry and survey.
I've loaded in my data and created the metric of (Survey Date-Enquiry Date) as Days between survey and Enquiry
I've then noconcatenated this and loaded it again as a proper field.
Then tried to do
Avg(Days between Enquiry and Survey) as Avg Days.
When I load this in it kicks up a fuss.
Does anyone know what I'm doing wrong?
Avg(Interval(Survey Date-Enquiry Date, 'DD')) as Days
What this is returning?
Interval(Survey Date-Enquiry Date, 'DD')
Sorry, I don't understand what you mean by a clause..
In my data load I tried doing this:
Resident Enquiries, group by Branch
(All formatted correctly) which it didn't like, is that what you mean?
Group by needs to include all the fields that are listed outside of aggregation... so, Year, Month, MonthYear etc will all need to go into Group By or you need to remove all fields except Brand from your Load...