Basic Question

[Alaric]

Hi,

How can I use an expression to select all values between 2 input values (vMin & vMax using [Input Box]) within the field "resale_price" (data consist from $5000 to $1,400,000) 

I am using a [Button] to filter for all values within the range of vMin & vMax and could not find the expression to it.

E.g. if I input $1,000,000 as vMin and $1,400,000 as vMax, all values between $1,000,000 and $1,400,000 will be shown

Thank you.

[kaushiknsolanki]

You should use Set analysis to do this.

For example.

Sum({<resale_price = {">=$(vMin)<=$(vMax)"}>}resale_price)

[Alaric]

Thank you for your help.

I tried entering the expression into the [Button]. It didn't show any error but clicking the button didn't filter the data set.

[kaushiknsolanki]

It wont work on the button, this has to be there in your chart expression.

[Alaric]

hm... is there a way to use a button to filter within the range?