topic How to select range from pivot table one field by using input box in QlikView

How to select range from pivot table one field by using input box

Wed, 03 Dec 2014 04:25:42 GMT

Hi,

Please any body let me know how can i select range of the specific field in pivot table using input box for range selection.

vardhancse — Wed, 03 Dec 2014 04:29:15 GMT

1.Create one variable

2. create one input box using the variable

3. in expression use the variable

So based on the variable value the expression will change.

Wed, 03 Dec 2014 04:37:29 GMT

please can u explain it with Example along with image file because i am using personal version

Thanks

Vasudha

vardhancse — Wed, 03 Dec 2014 05:05:49 GMT

in settings->variable overview->create one variable vExpression(Can be any thing) and give some value to that variable.

now create one input box object using teh variable vExpression.

In chart expressions use this variable so that

Eg: count({<Input={'<=$(vExpression)'}>}ID

So that it will take count of ID where input field is the variable value.

when ever we change value in input box the value in expression will change