topic Re: Input number variable. in QlikView

Input number variable.

Anonymous — Fri, 11 Apr 2014 15:13:22 GMT

I created a report that displays the Top 10 largest contributors, now I want to give users the opinion to dynamically change the number of largest by inputting their own number.Can anyone please walk me through thanks.

Re: Input number variable.

MK_QSL — Fri, 11 Apr 2014 15:16:36 GMT

Looks like you have used Rank Function as either calculated dimension or in set analysis...

You can create a variable

vTOP = 10

Now create an input box and keep vTOP in that.. Use can chagne any number replacing 10.

Now in Rank where you have used 10, use $(vTOP)

if you have used Dimension limit

Select Largest and use $(vTOP) instead of 10.

Re: Input number variable.

Fri, 11 Apr 2014 15:17:39 GMT

You used Dimension limits?

Re: Input number variable.

Fri, 11 Apr 2014 15:53:51 GMT

Declare a Input Field in the script and then in deimension limits or in set function use the Input field.

Qlikview INPUTFIELD by RFB 125 - YouTube