List of items greater than a certain value

[#1]

Hi

I want to create a expression , where the result is greater than a certain value.  In the table below, i only want to see item codes greater than  FEA.  How do i do this.

Thanking you in advance.

kind regards

Nayan

Item Code

FBWP

FBWP3

FBWP3/M

FBWP5

FBWP5/M

FBWPP

FBWPPE

FBWT5

FCA3S2

FCA4S

FCE2X3WS

FCE2X5WS

FCE2X10WS

FCER15W

FCER20W16

FCER25W

FCER30W

FCLP31

FCLP51

FCWP3

FCWP5

FEA1/2

FEA1/2GL

FEA2X16

FEA2X16GL

FEA3S

FEA3X16

FEA3X16GL

FEA4S

FEAPT

FEATA

FEATA1

FEBPHOME

FEC0/75BL

FEC0/75W

FEC1/0W2

FEC1/5W

FEC2/5BL

FEC2/5W

FEE2X/3W10SC

[#2]

You can create a set analysis:

{<ItemCode = {">EFA"} >}

Insert it into your different expressions of the table or chart.

Fabrice

[swuehl]

LOAD [Item Code] RESIDENT YourTable WHERE [Item Code] > 'FEA';

like for example:

LOAD * INLINE [

Item Code

FBWP

FBWP3

FBWP3/M

FBWP5

FBWP5/M

FBWPP

FBWPPE

FBWT5

FCA3S2

FCA4S

FCE2X3WS

FCE2X5WS

FCE2X10WS

FCER15W

FCER20W16

FCER25W

FCER30W

FCLP31

FCLP51

FCWP3

FCWP5

FEA1/2

FEA1/2GL

FEA2X16

FEA2X16GL

FEA3S

FEA3X16

FEA3X16GL

FEA4S

FEAPT

FEATA

FEATA1

FEBPHOME

FEC0/75BL

FEC0/75W

FEC1/0W2

FEC1/5W

FEC2/5BL

FEC2/5W

FEE2X/3W10SC

] WHERE [Item Code] > 'FEA';

[#4]

Thank you Fabrice

[#5]

Hi Swuehl

Thanks .  If i do the scripting on the front end (ie chart straight tabel), will it look like this

If ([Item code] > 'FEA', [Item code],Null())

kind regards

Nayan

[swuehl · Accepted solution]

Yes, this should work in the front end:

=count( if([Item Code]>'FEA',[Item Code]) )

[#7]

thank you Swuehl