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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
JohBeNeLux
Contributor
Contributor

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)
0 Replies