date comparisons

Tue, 07 May 2013 16:17:17 GMT

Hi,

I'm having trouble comparing dates using set analysis:

I need to count the following:

1) Number of patients where [Death_Date] is 7 days or less after [surgery_1_date]

2) Number of patients where [Death_Date] is between 8 days post [surgery_1_date] and [surgery_2_date]

3) Number of patients where [Death_Date] is after [discharge date] but before [surgery_2_date] ONLY WHERE [admit_type] ='1'

the best i have is:

=count({$<DEATH_DATE = {"<$(=[surgery_1_date]+7"}>} PAT_ID)

and it doesn't work!

i can't figure out how to intergrate the more elaborate conditions.

please help!

Thanks!!

Re: date comparisons

Anonymous — Tue, 07 May 2013 20:31:30 GMT

Usualy the problem with dates in set analysis is with formatting. Most likely the DEATH_DATE is in date format, and [surgery_1_date]+7 is certainly a number, even if [surgery_1_date] is a date.
Try this:

=count({$<DEATH_DATE = {"<$(=date([surgery_1_date]+7)"}>} PAT_ID)

Regards,

Michael

topic Re: date comparisons in QlikView

date comparisons

Re: date comparisons