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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JohBeNeLux
Contributor
Contributor
‎2019-06-17 09:41 AM

Transformation of Averageif formula from Excel in QS

Hi everybody, 

I am new in working with QS and I try to transform my excel function with which I calculated my base sales into a formula which works for QS. 

=AVERAGEIF(K4:AF4;"<"&(AVERAGE(K4:AF4)+STDEV(K4:AF4))

Can someone help me with this please?

Thank you. 

 

 

Labels (1)
Labels
546 Views
0 Likes
0 Replies