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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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