Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank and Input Box

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

5 Replies
swuehl
MVP
MVP

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?

Not applicable
Author

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!

Not applicable
Author

It returns all the values

swuehl
MVP
MVP

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
Specialist III
Specialist III

maybe if you add your rank in the set analysis

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