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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count of accounts for last 3 consecutive months with <100$ change in the sales amount

Hi Team,

I wanted to calculate the number of accounts as of month which is not grown >100$ for the last 3 months.  Please help how to calculate this.  I have attached the sample qvw.

Thanks in advance.

1 Reply
sivarajs
Specialist II
Specialist II

Sum({<Month_Num={">=$(=Max(Month_Num)-2)<=$(=Max(Month_Num))"},Amount={'<100'}>} Amount)