Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

List of items greater than a certain value

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
1 Solution

Accepted Solutions
MVP
MVP

Re: List of items greater than a certain value

Yes, this should work in the front end:

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

6 Replies
Not applicable

Re: List of items greater than a certain value

You can create a set analysis:

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

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

Fabrice

MVP
MVP

Re: List of items greater than a certain value

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';

Not applicable

Re: List of items greater than a certain value

Thank you Fabrice

Not applicable

Re: List of items greater than a certain value

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

MVP
MVP

Re: List of items greater than a certain value

Yes, this should work in the front end:

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

Not applicable

Re: List of items greater than a certain value

thank you Swuehl

Community Browser