topic Input Box to change Amount in QlikView

Input Box to change Amount

ivandrago — Mon, 21 Feb 2011 10:47:22 GMT

Hi,

I have the attached document, I have to Input Box

SalesFrom

SalesTo

When I entered a figure in both of the boxes I want it to filter the SalesAmount figure? I created to variables but not sure how to incorporate this so the SalesAmount figure changes.

Thanks

Input Box to change Amount

Mon, 21 Feb 2011 10:57:32 GMT

Please check.

Input Box to change Amount

deepakk — Mon, 21 Feb 2011 11:12:05 GMT

YOu can use it below way.

Sum({<AMount= {">= $(v1) <= $(v2)"}>} AMount)

where v1 and v2 are variables

Input Box to change Amount

ivandrago — Mon, 21 Feb 2011 13:41:08 GMT

Is it possible for a way to have it filter all the other fields

Input Box to change Amount

ivandrago — Mon, 21 Feb 2011 22:56:16 GMT

Hi,

Is this possible? Thanks

Input Box to change Amount

stevedark — Mon, 21 Feb 2011 23:34:52 GMT

Hi Ivan,

This is possible. You just need to construct an expression and attach it to the selection criteria for the amount.

I have amended the previous version of your document to add a button which assigns the following to the selection:

='=SalesAmount >= $(SalesFrom) and SalesAmount <= $(SalesTo)'

I have also attached the same action to Triggers that are attached to the add and update actions of the two variables.

This should achieve what you are after.

Post back if you need further assistance.

Regards,
Steve

Input Box to change Amount

deepakk — Tue, 22 Feb 2011 04:44:55 GMT

hi,

copy paste this code to all the required expression.

{<AMount= {">= $(v1) <= $(v2)"}>}

Input Box to change Amount

ivandrago — Tue, 22 Feb 2011 23:57:45 GMT

Thanks Mark, that works great! It won't let me choose this as answer not giving me the option for some reason?