Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
thanks sfatoux72. It worked.
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)) )'