topic Re: Select in field input box in QlikView

Select in field input box

Thu, 02 Jul 2015 20:05:49 GMT

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.

Re: Select in field input box

Qrishna — Thu, 02 Jul 2015 20:26:12 GMT

are you using a st table or a pivot?

Re: Select in field input box

Qrishna — Thu, 02 Jul 2015 20:30:26 GMT

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

Re: Select in field input box

Anonymous — Thu, 02 Jul 2015 20:31:56 GMT

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

Re: Select in field input box

Mon, 06 Jul 2015 13:12:10 GMT

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