Filter Condition

[#1]

How to Add a filter for: Margin > X and Margin < X

[hic]

The proper way to let users set filters in QlikView is to let them click in a list box. If there are too many values in the Margin list box, then you can create an extra field in the script, e.g.

class( Margin,100 ) as MarginClasses

[#3]

I tried as below:

1. create 2 input boxes. One for From and second for To value

2. Then in expression: I have

sum( {$<Margin = {"<=$(vTo)>=$(vFrom)"}>} Margin)

This is not working as desired although it filters some data in report.

Any idea whats wrong in this expression?

[#4]

class( Margin,100 ) as MarginClasses

above statement is giving error.

Margin is calculated as Revenue - Actual

[#5]

Can someone suggest why below expression is not working?

sum( {$<Margin = {"<=$(vTo)>=$(vFrom)"}>} Margin)

where vTo and vFrom are variables