Concat for Top positions

[#1]

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?

[#2]

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.

[#3 · Accepted solution]

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. )