Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Last Month, Previous Month and Average Number

Hello one an all,

I am trying to work out how to show last months activity, the previous months activity and the avergae number of activity, but not sure how to go about this?

Ideally I would like to show the figures along with the text in a text object at the top of the dashboard.

Below is the expression that I am currently using to calculate the overall totals.

sum({$<Metric_Code={'RTT9'}>} Monthly_Activity)

Any help would be greatly received and much appreciated!

0 Replies