topic Re: use inputbox & tablebox in QlikView

use inputbox & tablebox

jim_chan — Mon, 01 Aug 2016 07:44:14 GMT

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

Re: use inputbox & tablebox

amit_saini — Mon, 01 Aug 2016 07:49:23 GMT

Hi Jim,

See the attachment and check properties.

Hope this will help u!

Thanks,

Re: use inputbox & tablebox

jim_chan — Mon, 01 Aug 2016 07:52:11 GMT

But my scenario is user wants to key in From and To. not just vTop.

Re: use inputbox & tablebox

avinashelite — Mon, 01 Aug 2016 07:57:31 GMT

Try like this

if(field_name>vFromAmount and field_name<vToAmount,field_name)

Re: use inputbox & tablebox

amit_saini — Mon, 01 Aug 2016 07:59:33 GMT

Like this???

Same concept you can use for "From and To"

Thanks,

Re: use inputbox & tablebox

jonathandienst — Mon, 01 Aug 2016 08:06:36 GMT

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.

Re: use inputbox & tablebox

jim_chan — Mon, 01 Aug 2016 08:38:46 GMT

Bro Avin,

U saved me again

thanks bro! it solved my issue!

Rgds

Jim