Calculate Last Weekending on Chart

[waqasshah]

Dear All,

I  want to  sum all of the values only in last weekend.  Infact I want to know the total number of patients came for their appointments in last week  in particular specialty . e.g  the table also attached an excel sheet

I want to display value only for weekending  06/09/2020 (6th September 202) as 130 for Cardiology where type is FollowUp

I want to display value only for weekending  06/09/2020 (6th September 202) as 42 for Dental where type is FollowUp

but not the values for weekending 30/08/2020

Please also review the attachments  for data file and chart I want to display

WeekEnding	Type	Hospital Name	Specialty	Appointments
06/09/2020	FollowUp	Hospital One	Cardiology	40
06/09/2020	FollowUp	Hospital One	Cardiology	70
06/09/2020	FollowUp	Hospital Two	Cardiology	20
06/09/2020	FollowUp	Hospital Two	Dental	30
06/09/2020	FollowUp	Hospital One	Dental	8
06/09/2020	FollowUp	Hospital Two	Dental	4
30/08/2020	New	Hospital One	A & E	4
30/08/2020	New	Hospital One	A & E	6
30/08/2020	New	Hospital One	A & E	7
30/08/2020	New	Hospital One	Gastro	9
30/08/2020	New	Hospital One	Gastro	100

Regards

Waqas SHah

[Kushal_Chawda · Accepted solution]

@waqasshah  Try below. Create table with Dimension WeekEnding and Specialty and below expression

=sum({<Type={'FollowUp'},WeekEnding={"$(=date(max(WeekEnding)))"}>}Appointments)

[waqasshah]

Thanks for your reply. Unfortunately I am getting zero value. any change required in date format? Can you please upload your QV file ? Please  display it as Tabular bar .

[Brett_Bleess · Accepted solution]

What would likely be most helpful is if you attach your QVW, so folks can review data model etc...

Regards,
Brett