Using a bar chart to show which orders have not been updated in the over 7 days.

[nicouek]

Hi, community

Sorry, my original question was not well articulated, my apologies.

PROBLEM

Show the number of date [Order Date] that  have not been updated in over 7 days by Sales Rep?

dimension = Sales Rep

Measure = Count() dates in the [Order Date] FIELD which are over 7 day.

I hope I made sense this time. (Qlik Sense)

[MayilVahanan]

Hi

You can bring the field in the script

Load *, floor(today())-floor(updatedDate) as NoOfDays from yourdatasource;

Then in the front end, try like below

Count({<NoOfDays= {"<=7"}>}Distinct Orders)

[nicouek]

Hi, Mayil

My apologies my question was not clear. Thank you

I have updated the question and would appreciate your input.

Thank you again