Input Box from selecting Range of values

[#1]

Hi,

I have a requirement to accept the values from the user between From and To values using input box, Based on that input value, my table should show the aggregated value between that specified Range.

Can Anyone help me with this...

Thanks,

Vasant

[#2]

Thanks Kush,

Your logic is working good. But when there is no value in 'From' & 'To' field , the table shows zero values. So I consider the logic given by sfatoux72  using button selection.

[#3]

thanks sfatoux72. It worked.

[sfatoux72]

Hi Vasant,

I see your answer to Kush about the fact that set analysis did not work when no value in 'From' & 'To' field.

Given that in my reply there was the solution button and set analysis (which does not work either if the fields are empty).

Here is a new qvw that takes into account the empty fields using default value: 0 for vFrom and 1E9 (1'000'000'000) for VTO.

You will find corrections (in orange) for solutions with button and with set analysis

Expression with Set Analysis:

sum({$<[customer name]={"=(sum(amount)>= $(=alt(vFrom,0))) and (sum(amount)<= $(=alt(vTo,1E9)))"}>}amount)

Actions "Select in Field" in field "[customer name]":

='=(sum(amount)>= $(=Alt(vFrom,0)))  and (sum(amount)<= $(=Alt(vTo,1E9)) )'

[marjan_it]

thank you for your good answer. How can I add if in expression. for example my expression is
count(DISTINCT( if(FlowStatusID='19',MessageID)))
would you help me?

[marjan_it]

thank you for your good answer. How can I add if in expression. for example my expression is
count(DISTINCT( if(FlowStatusID='19',MessageID)))
would you help me?