topic Re: Set Analysis Query - calculate avg value based on max date in QlikView

Set Analysis Query - calculate avg value based on max date

Fri, 14 Nov 2014 14:33:24 GMT

I've been trying to work out average turnover for a group of companies based on a the most recent date available, but there's an error in my set analysis somewhere and I'm hoping someone can point it out! Any and all help would be greatly appreciated

=Avg(

{<Date={$(=Max(Date))}>}

Turnover)

Many thanks

Re: Set Analysis Query - calculate avg value based on max date

giakoum — Fri, 14 Nov 2014 14:36:09 GMT

try putting the expression in a varable :

=Avg(

{<Date={"$(Variable1)"}>}

Turnover)

or add double quotes:

=Avg(

{<Date={"$(=Max(Date))"}>}

Turnover)

Re: Set Analysis Query - calculate avg value based on max date

Fri, 14 Nov 2014 14:40:53 GMT

Thanks Ioannis - double quotes worked perfectly