Flags

[ajsjoshua]

Dear all,

I am calculating the patients who are visited again and so i had created flag in script and called in set analysis.

If(Peek(patientid)=patientid,1,0) as revisit

=count({<revisit={1},Year={'$(=max(Year))'}>} patientid)

But i am not getting the answer. In this case my answer should be 2.

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

[zhadrakas]

can you share a sample qvw for this?

[siddharth_s3]

Did you sort your data by patient ID?

Peek just looks at the previous row.

[Anil_Babu_Samineni]

Perhaps this?

If(patientid=Previous(patientid),1,0) as revisit // But, In your data there is not common with current to previous

[ajsjoshua]

Dear Tim,

PFA for qvw.

Regards,

Joshua.

[ajsjoshua]

Dear Siddharth,

Yes based on Date .

[zhadrakas]

i think your data needed to be sorted by Patient iD like Siddarth said.

try this script to test that:

patient:
Load
patientid,
type,
Date,
If(patientid=Previous(patientid),1,0) as revisit,
revenue,
discount
;
Load
patientid,
type,
Date,
revenue,
discount
ORDER BY patientid ASC
;
LOAD patientid,
type,
date as Date,
revenue,
discount
FROM
E:\Qlik\healthcare\Sukra\samp.xlsx
(ooxml, embedded labels, table is Sheet1);

[ajsjoshua]

Dear Anil,

I am sorting the data based on Patient.

[ajsjoshua]

Dear Tim,

By using this script and expression =count({<revisit={1},Year={'$(=max(Year))'}>} patientid)

I am getting 5 but i want 2.

[siddharth_s3]

Sort it by patient id and then date.

Unless there is a reason you are sorting it by date first.

You would have to try a different approach if you have to sort the data by date first.