On the fly calculation of an expression

[QlikDeveloper]

Hi,

I have a straight table,in which we use expressions to show the "Profit" and other details  for each product.

We calculate the "Profit" on the fly(depending on the selections).In the same table we have a "Range" column,which is calculated on the basis of "Profit". Now, I need another object to select the "Range".

Product Name(Not Null)	Mfg Date(Not Null)	Profit	Range	Quantity
abc	1/10/2014	70000	0-100000	4
xyz	1/10/2014	500000	400001-500000	5
asdf	1/10/2014	150000	100001-400000	6

To elaborate,the above table is my staright table.I have some predefined "Range",Like 0-100000,100001-400000 ,400001-500000 .Now I need another object(List Box or anything) of "Range" so that I can select the table depending on the range.

How to implement this logic?

[JonnyPoole]

You can create list boxes of expressions. 

What is the expression that determines Range ?

Try creating a list box and from the 'general' tab of the list box properties, change 'field' and scroll to the bottom to select 'expression' and then pop in your range expression.

If it doesn't work perfectly just post the experssion so we can debug here.