topic Re: Calculate Last Weekending on Chart in QlikView

Calculate Last Weekending on Chart

waqasshah — Fri, 11 Sep 2020 00:25:05 GMT

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

Re: Calculate Last Weekending on Chart

Kushal_Chawda — Fri, 11 Sep 2020 10:01:26 GMT

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

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

Re: Calculate Last Weekending on Chart

waqasshah — Fri, 11 Sep 2020 10:48:27 GMT

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 .

Re: Calculate Last Weekending on Chart

Brett_Bleess — Wed, 23 Sep 2020 11:42:12 GMT

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

Regards,
Brett