Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to Add a filter for: Margin > X and Margin < X
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
class( Margin,100 ) as MarginClasses
above statement is giving error.
Margin is calculated as Revenue - Actual
Can someone suggest why below expression is not working?
sum( {$<Margin = {"<=$(vTo)>=$(vFrom)"}>} Margin)
where vTo and vFrom are variables