Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have created a table box. user wants to add certain amount (from)input box and (to)input box , then display values that within the from and to.
For the expression , i have created into Variable - vTotalAmount. Then i have created to inputbox, and their variables are vFromAmount and vToAmount.
But i do not know how to add all these into a script.
Help guys!
Rgds
Jim
Try like this
if(field_name>vFromAmount and field_name<vToAmount,field_name)
Hi Jim,
See the attachment and check properties.
Hope this will help u!
Thanks,
AS
But my scenario is user wants to key in From and To. not just vTop.
Try like this
if(field_name>vFromAmount and field_name<vToAmount,field_name)
Like this???
Same concept you can use for "From and To"
Thanks,
AS
Well you can't add filter to a table box as it does not take expression. However, the table box will respect any user selections.
Or do you mean 'straight table'? If so, you can use set analysis to filter the table expression(s) (best) or use a calculated dimension which uses the from and to values (not ideal for a large data set). If the from and to values are dates, make sure that the date field you are using for the filtering is a numerical QV date value and not a string value.
If you need more specific help, I suggest that you upload a small sample qvw that contains some representative data.
Bro Avin,
U saved me again
thanks bro! it solved my issue!
Rgds
Jim