Hello Qlik Sense lovers!
I have an assignment to create a Bar Chart showing (number of incidents that have not been update in over 7 days since entered by techs in the company). I have also being asked to display the Sum() of all these dates(days) in the Label Box right on top of the object with a text displaying-->
XXX01 Incidents have not been updated in over 7 days. (Number has to update when there is a change in the data)
I would be glad if someone could assist with:
#1 How do I count() dates that are older than 7 days entered by techs?
#2 How to do I make the total of those days display in the Label Box?
Thank you