8 Replies Latest reply on Aug 2, 2017 11:42 PM by hannah.rhrbein

# First date in the current view

Hi everyone,

I filtered my data, so I can only see cases of patients that meet special conditions. I'd like to know the first data a patient meet the conditions. I've tried it with MIN and with FIXED, but then I get the first date a patient visit the hospital, not the first date a patient meet the conditions and is shown at the current view. Is there a chance to get the first data of a patient in the current view?

In this example I would like to see only the "3.Juni 2011" (= 3rd june 2011) for patient "2072".

It would be also perfect to get a variable that shows a "1" for the first date and a "0" for every other date of a patient, because I'd like to characterise the patiens on that special date afterwards.

I hope you understand what's my intention and that someone can help me.

Hannah

• ###### 1. Re: First date in the current view

Hi Hannah,

Find the attached twbx file.

first to find out the min date by using below calculation

calculation 1 :-  { FIXED :MIN([Order Date])}

Next Calculation 2 :- IIF([Order Date]=[Calculation1],'1','0')

Here the '1' shows Min Date and the '0' shows for the rest of the dates

Thanks ,

Gopi

• ###### 2. Re: First date in the current view

Hi,

thank you. But I'd like to know the first date for every patient, maybe that was not clear. When I use that calculations I get the first date a patient was there/ in your example the first orderdate in the data. I need the first date for every patient in the current view (with filter). That mean patient 2072 could have a date earlier in the whole dataset I'm not interested in.

regards,

Hannah

• ###### 3. Re: First date in the current view

Can you check on the below screenshot and let me know if this is what you are looking for !!

• ###### 4. Re: First date in the current view

Hello,

Please refer the below snapshot sheet 2. If this is you are looking for then you just need to create a calculated field as

First Date={FIXED [Patienten]:MIN([Monat,Tag])}

I have attached the workbook 10.3 also.

TG

• ###### 5. Re: First date in the current view

Use the below calculation

{Fixed [Patient ID]:MIN(Order date)}

instead of calculation 1

then it'll work definitely

Thanks,

Gopi

• ###### 6. Re: First date in the current view

Hi,

thanks, but unfortunately it doesn't work. I've created a twbx-file, maybe you have an idea. I'd like to have the first date of patient 2 and patient 3. Maybe you'll see the problem in the twbx-file.

Thanks,

Hannah

• ###### 7. Re: First date in the current view

Hi Hannah,

You need the patients list when there's a difference <=365 days with in two admissions right

or else could you please explain this to me briefly

Thanks,

Gopi

• ###### 8. Re: First date in the current view

Hi Gopi,

yes when there's a difference <= 365 days with in two admissions with the same diagnosis. And I need the first date when a patient meet that condition. The ambition: I want to characterise patients at this date (how old are they and so on), so perfectly I would need a variable I can use as a filter so I can calculate e.g. the average age of that patients.

IThanks,

Hannah