Solved: How to build an aggregated table after QVD - Qlik Community

helen_pip · ‎2012-09-26

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 · ‎2012-09-26

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;

View solution in original post

whiteline · ‎2012-09-26

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 · ‎2012-09-26

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 · ‎2012-09-26

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 · ‎2012-09-26

Thanks for your help!

I am a little further along now