Please help find an expression to use in a chart.

[#1]

Hi

Please could someone help me with the following.

I have the following data below. I am trying to create a chart that will display all the ID's that dont have Message Type '010'. Is there an expression i can use to do this?

From the Data that is below i would expect ID's 2,3,4 and 5 to be in my chart.

Many thanks in advance

ID	Message type
1	010CTRL
1	010
1	105
2	010CTRL
3	010CTRL
4	010CTRL
5	010CTRL
6	010CTRL
6	010
6	105
7	010CTRL
7	010
7	105

[sunny_talwar · Accepted solution]

Try this set analysis in your expression

{<ID = e({<[Message type] = {'010'}>}ID)>}

[#3]

Thank you Very much

[sunny_talwar]

Not a problem