Discussion board where members can get started with QlikView.
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
Go to 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;
returns the aggregated median of expression over a number of records as defined by a group by clause.
Load Class, Median(Grade) as MG from abc.csv group by Class;
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
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 for your help!
I am a little further along now