Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Select in field input box

Hi Community,

Quick question about select in field..

I have a table with an expression that spits out a % in each row. I want users to be able to filter based on the % but the problem is that it is not a dimension...

i want to have a input box where they type the % they want to see and it selects those and displays only that in the table.

any ideas? i tried using variables and using this link but no luck .

Selection in field through input box.

4 Replies
krishna_2644
Valued Contributor III

Re: Select in field input box

are you using a st table or a pivot?

krishna_2644
Valued Contributor III

Re: Select in field input box

If you are using a st table

Then make the expression as a calculated dimension  and goto presentation tab and hide the dimension column.

Now you should be good in making the selections and it reflects in the table too.

Thanks

Highlighted
mov
Esteemed Contributor III

Re: Select in field input box

You have to make a selection in chart dimension based on the same expression you use in the chart, comparing it against the variable of the input box.

See attached

Not applicable

Re: Select in field input box

the problem is i have to use an expression... You used a dimension for your search in field. How can you search inside expression?