Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
chchan674
Contributor III
Contributor III

Calculate expression based on Input box variable

Hi All,

Recently, I want to create a dashboard which can quote the total price.

For example, when the user type "10" in the input box, assume the unit price is "$5", the total price will show 50 automatically.

 Could anyone how to do it?

Thanks a lot.

Best regards,

Michael

6 Replies
Anil_Babu_Samineni

There is no straight forward for this. but, you can use Variable extension to achieve this? 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tresesco
MVP
MVP

While you create an input box, you get to provide a variable to hold the value, say it's vInput. Then you could just use the variable in your expression like :

= [Unit Price]*vInput
Lucke_Hallbergson

One example how it could be done is attached;

input.png

chchan674
Contributor III
Contributor III
Author

Thanks a lot.

I will try it and report to everyone.

chchan674
Contributor III
Contributor III
Author

Thanks a lot.

Where can i create an input box for user to input the value?

 

Lucke_Hallbergson

Add from Custom Objects/Qlik dashboard bundle ( Variable input).
Then create a variable by clicking variable input button here;

variable.png