Choosing Values

[#1]

Hello:

Im a new qlikview user.

I have a list of, say, employee numbers 1-1000 in the first column of the table. With each row on that table having more information on those employee numbers. How can I make a button that will make the table display only employee numbers that are, say, 900? or a range of employee numbers like 300-400?

Thanks!

[#2]

Hi

You can use variable to show the values of your table/charts

use the expression in your dimension:

IF(number_employee = variable_1, number_employee) 

If you want a range:

IF(number_employee >= variable_1 AND number_employee <= variable_2, number_employee)

You need create the variable using input box.

[jonathandienst · Accepted solution]

Hi

Create a button, and for the actions, add a "Select in Field" action, add the field name in the field box. For the Search String,

     900                           will select only 900

     >=100 <200               will slect 100-199

     ='(100 | 200| 900)'       will select 100, 200, 900

Hope that helps

Jonathan

[#4]

That worked great! thanks!

What if I wanted to do two different ranges with the same button? so perhaps greater than 900 and less than 100?

[jonathandienst]

Use "<100 >900" (without the quotes) in the search string box.

Jonathan

[#6]

Im sorry I spoke wrong. I meant two different ranges. For example, less than 900 but greater than 700. Also less than 300 but greater than 100, all with the same button.

[#7]

Im sorry I spoke wrong. I meant two different ranges. For example, less than 900 but greater than 700. Also less than 300 but greater than 100, all with the same button.

[#8]

Hi

See this example with button and variable.

[#9]

How would I go about using wildcards to do this?

I really only care for the values in the column that start with 5 and 6. I can get it to select the values that start with, ie 5, but cant get it to select both 5 and 6.

This works for selecting 5...

= '5*'

but I don't know how to select values starting with 5 and 6.

[#10]

How would I go about using wildcards to do this?

I really only care for the values in the column that start with 5 and 6. I can get it to select the values that start with, ie 5, but cant get it to select both 5 and 6.

This works for selecting 5...

= '5*'

but I don't know how to select values starting with 5 and 6 at the same time.