Show a list of values in a Listbox excluding NA and Not Known values from another field?

[jblomqvist]

Hi all,

I have a field called FieldNumber. It contains the following values:

ValueNumber	Name
1	A1
2	A2
3	A3
4	A4
5	A5
6	A6
7	A7
8	A8
9	A9
10	A10
11	A11
12	A12
NA
NK

I would like to create a List Box that shows Name values sorted by ValueNumber but also exclude NA and NK values.

How can I do this please?

[Anonymous]

if you wan to exclude NA and NK you may use this Expression as Long as you only have numbers in other values

if (isnum(ValueNumber), Name)

[trdandamudi]

May be as attached:

[janarthanan_rb]

In the list box use expression and ignore the data that is gone to be excluded by using e() function in set analysis

[Anil_Babu_Samineni]

How about this

If(valuenumber <> 'na','nk', valuenumber)

[tresesco]

PFA for sample solution.

[tracysmart]

as an alternative to using a calculated Expression inside your list box you could create a subset in your Load Script. This is useful if you want to use this new subset Dimension in many other Charts/Listboxes.

you would do something like this in your script

Table_New:

LOAD

  ValueNumber,

  Name AS NewDimensionName

Resident Temp_Data

where not match (ValueNumber, 'NA', 'NK');

[miguelbraga]

Or even you do a more simplistic way like this:

Temp_Data:

LOAD * INLINE [

    ValueNumber, Name

    1, A1

    2, A2

    3, A3

    4, A4

    5, A5

    6, A6

    7, A7

    8, A8

    9, A9

    10, A10

    11, A11

    12, A12

    NA,

    NK

];

Table_New:

LOAD

  ValueNumber,

  Name AS NewDimensionName

Resident Temp_Data

where ValueNumber <> 'NA' and ValueNumber <> 'NK';

Drop Table Temp_Data;

Regards,

MB