topic Max and Min data from a field in QlikView

Max and Min data from a field

Anonymous — Sun, 11 Jul 2010 06:41:28 GMT

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?

Max and Min data from a field

Mon, 12 Jul 2010 09:38:43 GMT

Hi,

first idea are use the search capability of QlikView.

Does it work for you?

Good luck!

Rainer

Max and Min data from a field

Mon, 12 Jul 2010 09:50:52 GMT

Hi,

here are an example using variables and an inputbox.

Good luck!

Rainer

Max and Min data from a field

sunil2288 — Mon, 12 Jul 2010 09:59:44 GMT

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..

AW:Re: Max and Min data from a field

brenner_martina — Mon, 12 Jul 2010 10:28:41 GMT

Hi Ramya,

you can also use a slider with two variables!