topic Concat for Top positions in QlikView

Concat for Top positions

Fri, 08 Oct 2010 07:54:04 GMT

Hi everybody,

I try to write a Concat-Function.
The formula works only when there is no formula in the IF-Query.

The SID's that have a rank <= ceil(count(distinct sid)*Top) must be connected with Concat-Formula.

Example:
Top = 25%

This Formula does not work
concat(if(aggr(rank(count(sid)),id,sid)<=ceil(count(distinct sid)*Top),sid),', ')

And it works
concat(if(aggr(rank(count(sid)),id,sid)<=3,sid),', ')

The IF-query must work with ceil(count(distinct sid)*Top) because I need it in a Chart.

Does anyone know the problem?

AW:Concat for Top positions

Fri, 08 Oct 2010 14:00:17 GMT

This works well.

concat(if(aggr(rank(count(sid)),id,sid)<=$(=ceil(count(distinct sid)*Top),sid)),', ')

But if I write it this way, the top variable assigned only one value for all ID's.

AW:Concat for Top positions

Wed, 13 Oct 2010 15:05:34 GMT

Here the soloution:

concat(if(aggr(rank(count(sid)),id,sid)<=ceil( aggr( count(distinct total <id> sid),id,sid)*Top),sid),', ')

Thanks QlikTech Support (Mr. D. )