Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
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? 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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