Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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
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;
Thanks for your help!
I am a little further along now