How to show record null values

[#1]

hi all,

i have a table like this below

Employee id	Training Code
1	EST01
2	EST02
2
3	EST02

if i select from list box "EST01" i need show only employee 1 and 2

Is it possibile?

Tyvm

Simone

[MK_QSL]

What is the logic behind this? Please elaborate little more !

[Anonymous]

If You select EST01 You only have employee 1.

[#4]

My mistake.

i have to show only idEmp 2 and 3.

[Anonymous]

so when you select EST01, you show the values that are not corresponding to EST01?

[JonnyPoole]

If you want to show EMP 2 and 3 in a chart , SET Analysis can do this:

only( {$<[Training Code]=e([Training Code])> } [Training Code])

This will apply a filter to a chart to only show training codes in the set of codes that have NOT been selected.

Here is sample as well that works.