Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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. )
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.
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. )