Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz2
Contributor III
Contributor III

How to calculate average for last 3 months

Hello,

I have following expression and want to calculate the average of the last three months and display it as percentage:

(count( { <[input]= {"<1"}> } [id]))
* (100)
/ (count(id))

 

But i dont know how to do it. I tried that but it doesn't work:

(count( { <[input]= {"<1"}, [created_date] = {"[created_date] > MonthStart(Today(),-3)"}> } [id]))
* (100)
/ (count(id))

 

Help is much appreciated.

Best reagrds!

0 Replies