Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

ivandrago
Contributor II

Input Box to change Amount

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

1 Solution

Accepted Solutions
MVP
MVP

Input Box to change Amount

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

7 Replies
Not applicable

Input Box to change Amount

Please check.

deepakk
Valued Contributor III

Input Box to change Amount

hi

YOu can use it below way.

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

where v1 and v2 are variables

ivandrago
Contributor II

Input Box to change Amount

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

ivandrago
Contributor II

Input Box to change Amount

Hi,

Is this possible? Thanks

MVP
MVP

Input Box to change Amount

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

deepakk
Valued Contributor III

Input Box to change Amount

hi,

copy paste this code to all the required expression.

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

ivandrago
Contributor II

Input Box to change Amount

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

Community Browser