topic Re: Dynamic Dimension string error in QlikView

Dynamic Dimension string error

Fri, 20 Jun 2014 21:53:04 GMT

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

Re: Dynamic Dimension string error

swuehl — Fri, 20 Jun 2014 22:05:10 GMT

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

Re: Dynamic Dimension string error

fkeuroglian — Sat, 21 Jun 2014 00:52:38 GMT

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

thanks

Fernando