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
You could find in attachment a qvw with two solutions:
Do you have a sample where you are trying to implement? I am not sure what exactly is the problem?
Hi,
Check this,
PFA,
Hope this helps,
-Hirish
create the variable vFrom & vTo
I have below set of data
ID | Data | Number |
---|---|---|
101 | 100 | 1 |
101 | 200 | 2 |
101 | 300 | 3 |
101 | 400 | 4 |
101 | 500 | 5 |
101 | 600 | 6 |
to get the values between the number from 2 to 4 write below expression
=sum({<Number={">=$(=vFrom)<=$(=vTo)"}>}Data)
Hi Vasant,
To select a range of value of a numeric field, you could write directly on the search of the field : >=4 <10
You will have the selection of the following value : 4, 5, 6, 7, 8, 9
If you want to input box and a button:
Hi,
Check this too using multi-Box,
-Hirish
Hi All,
thanks for the response.. My requirement details are as follows ----
Assume that I have table shows like this
customer name sum(amount)
cust1 1200
cust2 2100
cust3 3000
cust4 4000
Now if I input the value in InputboxA>=2000 and InputboxB<=3000
then my table should show like this
customer name sum(amount)
cust2 2100
cust3 3000
thanks,
vasant
You could find in attachment a qvw with two solutions:
Create the straight table
Dimension:
Customer Name
Expression:
=sum({<[customer name]={"=sum(Amount)>=$(vFrom) and sum(Amount)<=$(vTo)"}>}Amount)