Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Dynamic Dimension string error

No idea why this wouldn't work, it does until I add the bolded portion:

IF(AGGR(RANK(SUM([AMOUNT USD])), [SUPPLIER NAME]) <= 10,AGGR(RANK(SUM([AMOUNT USD])),[SUPPLIER NAME]), 'Other '&(Count(TOTAL[SUPPLIER NAME])-10))

2 Replies
MVP
MVP

Re: Dynamic Dimension string error

What do you mean with 'wouldn't work'? Seems quite ok as your calculated dimension, besides I would add a DISTINCT qualifier and a space:

IF(AGGR(RANK(SUM([AMOUNT USD])), [SUPPLIER NAME]) <= 10,AGGR(RANK(SUM([AMOUNT USD])),[SUPPLIER NAME]), 'Other '&(Count(DISTINCT TOTAL [SUPPLIER NAME])-10))

fkeuroglian
Honored Contributor

Re: Dynamic Dimension string error

Hi can you put an example or tell what error do you have?

thanks

Fernando

Community Browser