How to build an aggregated table after QVD

[helen_pip]

Hello

I was wondering if someone could kindly help me

I would like to know some advice on how I can build an aggregated table after a qvd file has been created?

Any advice would be be greatly appreciated

[whiteline]

Hi.

Just use Load with a 'group by [Patient Admitted], MonthYear' statement.

And correct your expressions, for example, like this:

=Pick([Patient Admitted]+1, Median([Triage])/1440, Median([Total Wait])/1440) as Median

[helen_pip]

Hello

Thanks for the help

I have noticed that median is not a built in function in the edit script part.  Is there any other way of calculating the median in the edit script?

Thanks

Helen

[whiteline · Accepted solution]

I think you're missing something.

This is from QV help:

median (expression)

returns the aggregated median of expression over a number of records as defined by a group by clause.

Example:

Load Class, Median(Grade) as MG from abc.csv group by Class;

[helen_pip]

Thanks for your help!

I am a little further along now