topic Calculation (addition and subtraction )in Charts and Text Box in QlikView

Calculation (addition and subtraction )in Charts and Text Box

waqasshah — Sat, 16 Nov 2024 18:40:29 GMT

Hi All,

I need your help. It seems to be a simple calculation but it becomes complicated and I am unable to display what I want. I have attached the excel sheet for a sample. One tab is source data the other one is how I would like to display data in chart (straight table )and text boxes.

Following is the explanation

HospitalWardName : Shows show ward in a hospital

Patients In Each Ward: Shows Total Number of patients in each ward

Total Beds In Each Ward: Shows Total number of beds in each ward

Free Beds In wards: Shows total number of free wards

Although I have Free beds in wards field but it did not display data so I use the following calculation

Free Beds In wards = (Total Beds In Each Ward ) - ( Patients In Each Ward)

Same issue with the TEXT BOX I would like to display Free Beds In wards but it did not display anything

Can you please help ? Thanks In advance.

Please note in my original work I am using QVD files to get data and use my database values for calculations. Excel sheet is a reference only

Kind Regards

Re: Calculation (addition and subtraction )in Charts and Text Box

AshvitaKatkar — Sun, 10 May 2020 15:06:42 GMT

Hi Waqasshah,

Try below expression, I hope it will help you to get desire output

For table Chart & Textbox:

PatientsInEachWard : Sum(Aggr(Sum(DISTINCT PatientsInEachWard),HospitalWardName))

TotalBedsInWard : Sum(Aggr(Sum(DISTINCT TotalBedsInWard),HospitalWardName))

FreeBedsInWard: Sum(Aggr(Sum(DISTINCT TotalBedsInWard)-Sum(DISTINCT PatientsInEachWard),HospitalWardName))

Regards,

Ashvita

Re: Calculation (addition and subtraction )in Charts and Text Box

waqasshah — Sun, 10 May 2020 18:50:50 GMT

Dear Ashvita,

Thanks for your reply. Can you please upload the QVW file that you worked on ? I would like to play around.Again many thanks for your help.

Regards

Waqaas Shah

Re: Calculation (addition and subtraction )in Charts and Text Box

AshvitaKatkar — Wed, 13 May 2020 10:42:05 GMT

hi Waqasshah,

Sorry for late reply.

PFA.

Regards,

Ashvita