Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamic expression

Hi,

I need help with a concept that allow me to input my own amount rather using dimension limits.Importantly, I would very much like to use an INPUT BOX and the RANK FUNCTION eg.IF1000 is specified in the INPUT BOX SUM the totals of all amount greater than 1000.

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

If your input box variable is named vInput, then:

sum({<Amount = {">=$(vInput)"}>}Amount)

View solution in original post

3 Replies
Not applicable
Author

Try utilizing inputfields, they can be a part of a table box

Not applicable
Author

If your input box variable is named vInput, then:

sum({<Amount = {">=$(vInput)"}>}Amount)

its_anandrjs

If i am understand the values in your table is

LOAD * Inline

[

Customer,Value

America,1000

Brazil,1500

Russia,1400

];

And create a variable

Let vInputValue = 0; and with the input box enter the values in the variable

Then in expression write like

1. If(Value > $(vInputValue), Sum(Value))

2. And by SET analysis SUM({< Value = { '> $(vInputValue) '}  >} Value)