Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Choosing Values

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!

1 Solution

Accepted Solutions
MVP
MVP

Choosing Values

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
12 Replies
Not applicable

Choosing Values

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.

MVP
MVP

Choosing Values

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Choosing Values

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?

MVP
MVP

Re: Choosing Values

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

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Choosing Values

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.

Not applicable

Re: Choosing Values

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.

Not applicable

Re: Choosing Values

Hi

See this example with button and variable.

Not applicable

Re: Choosing Values

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.

Not applicable

Re: Choosing Values

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.

Community Browser