topic Re: Increase % calculation in QlikView

Increase % calculation

ajsjoshua — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

From the given data i want to calculate the patient increase % when the hospital gives discounts.

patientid	type	date	revenue	discount
1	Ip	2/3/2017	5000	250
2	Op	5/3/2017	4500	0
3	Op	18/4/2017	6000	0
4	Ip	23/4/2017	7000	350
5	Ip	1/5/2017	2000	0

Regards,

Joshua.

Re: Increase % calculation

Anil_Babu_Samineni — Wed, 17 Jan 2018 05:01:15 GMT

What is the calculation would be to calculate the % in your business.

Re: Increase % calculation

ajsjoshua — Wed, 17 Jan 2018 05:25:15 GMT

Dear Anil,

In the below data you can find the patientid 1 and 4 visited the hospital again because of discount which the hospital had given for their first visits.Now i want to calculate the patient increase % when there is discount.

patientid	type	date	revenue	discount
1	Op	2/3/2017	5000	250
2	Op	5/3/2017	4500	0
3	Op	18/4/2017	6000	0
4	Op	23/4/2017	7000	350
5	Op	1/5/2017	2000	0
1	Op	1/5/2017	3000	150
4	Op	2/5/2017	5000	250

Re: Increase % calculation

Anil_Babu_Samineni — Wed, 17 Jan 2018 07:22:10 GMT

That means, You are going to execute each row which based on patientid if id already exists in each when this happened to next again