topic Dynamic expression in QlikView

Dynamic expression

Anonymous — Wed, 11 Jun 2014 13:52:46 GMT

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

Re: Dynamic expression

Wed, 11 Jun 2014 13:54:21 GMT

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

Re: Dynamic expression

Wed, 11 Jun 2014 13:55:15 GMT

If your input box variable is named vInput, then:

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

Re: Dynamic expression

its_anandrjs — Wed, 11 Jun 2014 14:09:53 GMT

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)