Selection of a range in a table

[#1]

Hello

I have a simple question

I have a tabel with landnumber, i call the tabel also landnumber

In this tabel i have a lot of number Like

0001

0002

0003

0004

0005

0006

0007

0008

0010

0020

0030

0100

0125

0300

I only want to see a few numbers in the listto choose, eg 0001, 0002, 0030, 0125

I don't want to al the numbers.

In sql you can program where (landnumber= 0001) OR

                      (landnumber= 0002) OR

                      (landnumber= 0030) OR
                      (landnumber= 0125)

how can do this in qlikview

[swuehl]

Well, if you want actually select a bunch of number, you can create a list box for landnumber field, then click on the magnifying glass and enter exactely as given:

(0001|0002|0030|0125)

and press enter.

This selection will affect all objects in default state.

If you want to filter only one table, you could either use a calculated dimension or an expression with set analysis, for latter e.g create a table with landnumber as dimension (or another appropriate dimension) and as expression:

=only({<landnumber = {0001,0002,0030,0125} >} landnumber)

You can also hide this expression in presentation tab. All depends on what you want to achieve.

Regards,

Stefan

[IAMDV]

Hi giozedzed1,

Quick question... do you want to restrict these numbers in Script or Expression?

Cheers - DV

[#4]

In a axpression

I have thoose to make a list. In mthe list you see.

1

2

3

4

5

I only want to see

1

2

3

I only can thoose 1,2,3 to make a selection

[swuehl]

If you are talking about limiting a list box, you could create a list box field expression (General tab, select <expression> from field selector):

=if(match(landnumber,1,2,3),landnumber)