Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
JohBeNeLux
New 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.