New to Qlik Sense

[msawyercke]

Hi,

I'm trying to get an average of sales (field is 'Trailing 13') for just those locations where the 'Owner' is equal to 'I'.  I use the following simple formula, but  there is an error in the formula somewhere:

Avg {<[Owner]= ('I') >}[Trailing 13]

Additional info:  The 'Owner' and 'Trailing 13' fields are loaded from separate worksheets, and are connected by the field "PS#".  (Not certain if this additional information is useful, but perhaps is part of the issue).

I greatly appreciate anyone who can help with probably is a very simple problem.  😀

[Vegar]

The Syntax is wrong. Try this expression.

Avg( {<[Owner]= {'I'} >}[Trailing 13])

[msawyercke · Accepted solution]

Perfect - thank you, Vegar!