Max and Min data from a field

[Anonymous]

Hi

I have column which has the range of values 1- 2000, The column name is Num_Nodes,

I have to have an input box(any box to enter a value), called Max_Num_Nodes, when user enters a value in it say 200, the data has to appear where Num_Nodes values are less than 200,

Similar another input box , Min_Num_Nodes, and if user enters 100 in it the data has to appear where Num_nodes is greater than 100,

Could any body please help me in achiveing this?

[#2]

Hi,

first idea are use the search capability of QlikView.

Does it work for you?

Good luck!

Rainer

[#3]

Hi,

here are an example using variables and an inputbox.

Good luck!

Rainer

[sunil2288]

Hi Ramya,

You can create a variable using input box as Var_Num_Values. Then in the table where you fhave your data write the condition that

if(Num_Nodes<Var_Num_Nodes,sum(values))

Similarly for min value ..

Hope it will solve your problem..

[brenner_martina]

Hi Ramya,

you can also use a slider with two variables!