topic Re: How to do aggregation in expression column? in QlikView

How to do aggregation in expression column?

Mon, 01 Oct 2012 16:19:35 GMT

Hi Experts here,

I used count([ID]) and fabs(count([Hospital Number])-above(count([Hospital Number]))) expressions in in my chart and would like to get sum, mean and count of each expression.

Is there any way to do it?

Thanks

Re: How to do aggregation in expression column?

swuehl — Mon, 01 Oct 2012 19:04:43 GMT

Where do you want to show these aggregates?

For example, if you are using a straight table chart and to see one of the above aggregations in the total line, you can set the total mode in expression properties appropriately.

You can also consider using advanced aggregation.

If your expressions are used with a dimension DIM, you could try something like

=avg( aggr(count(ID), DIM))

= sum( aggr( count(ID), DIM))

e.g. in a text box.

Hope this helps,

Stefan

Re: How to do aggregation in expression column?

Mon, 01 Oct 2012 20:08:40 GMT

Your solution works for the first expression. How about the second expression fabs(count(ID)-above(count(ID))) ? I wanted to show the average for this expression on the chart and display in the textbox. I named this expression as MR(moving range), but I have no way to access it! How can I access and manipulate the aggregate value of this expression? I tried to use avg(MR), not working. I also tried to use avg(fabs(count(ID)-above(count(ID)))) still not working.

Thanks