topic Re: Rank and Input Box in QlikView

Rank and Input Box

Tue, 10 Nov 2015 16:57:49 GMT

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,

Re: Rank and Input Box

swuehl — Tue, 10 Nov 2015 17:10:20 GMT

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?

Re: Rank and Input Box

Tue, 10 Nov 2015 17:26:01 GMT

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!

Re: Rank and Input Box

Tue, 10 Nov 2015 17:27:11 GMT

It returns all the values

Re: Rank and Input Box

swuehl — Tue, 10 Nov 2015 18:52:28 GMT

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?

Re: Rank and Input Box

ramoncova06 — Tue, 10 Nov 2015 19:03:35 GMT

maybe if you add your rank in the set analysis

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