Rank and Input Box

[#1]

Hi,

I created an input box to limit a straight table dimension (Dimension Limits> Show only values that accumulate to: $(Variable)) and it works fine.

However, when I introduce a Rank column it doesn't limit like before.

Suggestions?

Thank you in advance,

JS

[swuehl]

Can you be a bit more specific what you get when you add the Rank column?

It seems to work for me, so I assume your setting is different or I misunderstood your issue.

Could you upload a small sample QVW?

[#3]

Sorry but I cannot upload it.

I have a dynamic limit dimension according to what the user introduces in an input box (I use a variable). It works fine until I add another column with the rank as the first column of table.

Basically, when I add that column it stops limiting the percentage of accumulated values introduced by the user.

Thanks!

[#4]

It returns all the values

[swuehl]

Ah, I missed that you are using the rank as first expression. The dimension limit will be based on first expression, I think that's what causing the issue.

Maybe just use the rank expression as second expression?

[ramoncova06]

maybe if you add your rank in the set analysis

sum({< ID ={"=rank(Sum({<fieldvalue={1}>}count)) < 200 "}>}Count)