Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
msawyercke
Creator
Creator

Simple Sales Formula

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.  😀

1 Solution

Accepted Solutions
msawyercke
Creator
Creator
Author

Perfect - thank you, Vegar!

View solution in original post

2 Replies
Vegar
MVP
MVP

The Syntax is wrong. Try this expression.


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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
msawyercke
Creator
Creator
Author

Perfect - thank you, Vegar!

View solution in original post