Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

use inputbox & tablebox

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

1 Solution

Accepted Solutions
Highlighted

Try like this

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

View solution in original post

6 Replies
Highlighted
Master III
Master III

Hi Jim,

See the attachment and check properties.

Hope this will help u!

Thanks,

AS

Highlighted
Creator III
Creator III

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

Highlighted

Try like this

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

View solution in original post

Highlighted
Master III
Master III

Like this???

Same concept you can use for "From and To"

Thanks,

AS

Highlighted

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Creator III
Creator III

Bro Avin,

U saved me again

thanks bro! it solved my issue!

Rgds

Jim