topic Re: Choosing Values in QlikView

Choosing Values

Mon, 11 Jun 2012 18:06:19 GMT

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!

Choosing Values

Mon, 11 Jun 2012 18:17:32 GMT

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.

Choosing Values

jonathandienst — Mon, 11 Jun 2012 18:24:01 GMT

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

Choosing Values

Mon, 11 Jun 2012 18:32:03 GMT

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?

Re: Choosing Values

jonathandienst — Tue, 12 Jun 2012 09:51:13 GMT

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

Jonathan

Re: Choosing Values

Tue, 12 Jun 2012 12:50:53 GMT

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.

Re: Choosing Values

Tue, 12 Jun 2012 12:51:07 GMT

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.

Re: Choosing Values

Tue, 12 Jun 2012 14:25:00 GMT

See this example with button and variable.

Re: Choosing Values

Tue, 12 Jun 2012 17:25:33 GMT

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.

Re: Choosing Values

Tue, 12 Jun 2012 17:25:39 GMT

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.

Re: Choosing Values

Tue, 12 Jun 2012 18:16:34 GMT

Hi,

You can use this MACRO:

SUB Range

ActiveDocument.Fields("YOUR_FIELD").Select "5*"

ActiveDocument.Fields("YOUR_FIELD").ToggleSelect "6*"

END SUB

Add a button using the macro.

Re: Choosing Values

Tue, 12 Jun 2012 18:22:05 GMT

Is there a different way to do it other than a macro?

Re: Choosing Values

Tue, 12 Jun 2012 18:29:36 GMT

Yes, i find now this way

Insert two action on your button

1. "Select in Field" on your field with the filter ="5*"

2. insert the "Toggle Select" on your field with the filter ="6*"