Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

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

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.

3 Replies
vardhancse
Valued Contributor III

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

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.

Not applicable

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

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

Thanks

Vasudha

vardhancse
Valued Contributor III

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

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