Inline calculations for row filter

[jgprime]

Hi all,
I’m sure that this is an easy task but I can’t figure out how to filter rows relative to a flow variable.
Column is integer and I want to be able to filter between a flow variable value and that number -30 (always minus 30).
column_value between (flow_var - 30) and flow_var

I have run into this type of problem a couple of times and figured out with one node or another, but without a general approach and am still wrapping my head around the Knime logic

[rfeigel]

Try this. You can create a component to incorporate the widget:
Inline Calculations for Row Filter.knwf (80.9 KB)

[jgprime]

Thank you for this. It wasn’t exactly what I was hoping for but it put me on the right track.

I don’t think that I articulated specifically what I was looking for: a range calculated from a user-specified input.
for example:
user input: Dec 25
range to be included: Nov 25 to Dec 25

I managed to solve it with the math formula variable node although it feels a bit clunky.

[rfeigel]

Here’s another approach with a user input widget.
Inline Calculations for Row Filter rev 1.knwf (86.1 KB)

[jgprime]

This is great to help with shifting dates, thank you.