Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
helen_pip
Contributor II

How to build an aggregated table after QVD

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

1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: How to build an aggregated table after QVD

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;

4 Replies
whiteline
Honored Contributor II

Re: How to build an aggregated table after QVD

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
Contributor II

Re: How to build an aggregated table after QVD

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
Honored Contributor II

Re: How to build an aggregated table after QVD

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
Contributor II

Re: How to build an aggregated table after QVD

Thanks for your help!

I am a little further along now

Community Browser