Set Expression for capturing some data

[nevilledhamsiri]

Hi,

I have a table like below

Code     values

77480     500

77170     1000

45150     450

78110    

77450

75150

Please write a set expression to get the list of codes which carries no values.

Thanks

Neville

[sunny_talwar]

You need this in which object? List Box? Chart?

[nevilledhamsiri]

please do it for both list box & chart

[sunny_talwar]

May be this for list box object

Aggr(Only({<Code = {"=Sum(values) = 0"}>} Code), Code)

For chart

Dimension

Code

Expression

Sum({<Code = {"=Sum(values) = 0"}>} Measure)

[nevilledhamsiri]

what is meant by measure ?

[sunny_talwar]

It is just a placeholder... I don't know what you are trying to do in a chart (at least you have not mentioned what you are looking to do in a chart)

[surendraj]

May be this!!

In List box-->Properties-->General-->Field-->Expression-->

if(Len(trim(values)=0,Code))

[nevilledhamsiri]

I made the expression as below which gives me even the codes with balances.I need following codes out of total list to be shown. Sorry for the trouble, please see what error I have made

78110   

77450

75150

Sum({<Code = {"=Sum(values) = 0"}>}CODE)

[sunny_talwar · Accepted solution]

If you field called CODE or Code? Use it consistently in your expression

Sum({<Code = {"=Sum(values) = 0"}>}CODE)

[nevilledhamsiri]

Dear Sunny,

Please see the attachment. CODE (Dimension) seems to be taken as it is at every point but could not get the results

Please see the error done