topic Re: Filter on data in QlikView

Filter on data

ranibosch — Fri, 10 Nov 2017 06:47:47 GMT

Hi,

I've got the following table:

Creation Day	Creation Month	Posting Day	Posting Month	Item No	Document Number	PO Number
1	Jun	1	Jun	PLWPEC002B	GRN042628	PO032791
1	Jun	30	May	FRUCOC001	GRN042678	PO033054
1	Jun	30	May	OIL03	GRN042622	PO032790
1	Jun	31	May	L100X107-0065	GRN042630	PO032879
1	Jun	31	May	L100X107-0118	GRN042679	PO032879
1	Jun	31	May	PEC001C	GRN042677	PO033115
1	Jun	31	May	PEC002C	107126
1	Jun	31	May	PEC002C	GRN042677	PO033115
1	Aug	1	Aug	PBWALM005/100	107166
1	Aug	1	Aug	PBWALM005/100	GRN043866	PO033057
1	Aug	1	Aug	PBWALM005/100	GRN043868	PO033057
1	Aug	27	Jul	FRUAPPL002/001	GRN043853	PO033065
1	Aug	27	Jul	FRUAPR002/001	GRN043853	PO033065
1	Aug	27	Jul	FRUITMIX001	GRN043853	PO033065
1	Aug	27	Jul	FRULOL001	GRN043853	PO033065
1	Aug	27	Jul	FRUPEA001	GRN043853	PO033065
1	Aug	27	Jul	FRUPEA003	GRN043853	PO033065
1	Aug	27	Jul	FRUPEAR	GRN043853	PO033065

How can I filter this data on the object / script to show only document numbers that start with "GRN"?

I do not want to see the numbers highlighted in red.

shraddha_g — Fri, 10 Nov 2017 06:52:58 GMT

Add below condition in script

Load *

From ....Source

Where wildmatch("Document Number",'GRN*');

karthikoffi27se — Fri, 10 Nov 2017 07:16:50 GMT

Hi Rani

In Object level you can use the wildmatch like GRN*

Many Thanks

Karthik

Anil_Babu_Samineni — Fri, 10 Nov 2017 07:17:20 GMT

In script:

Load * From Table where WildMatch([Document Number], 'GRN*');

Load * From Table where [Document Number] Like 'GRN?';

In front end:

Only({<[Document Number] = {'GRN*'} >} [Document Number])