how to set filter?

[#1]

Hi there,

I want to capture all begin with the 'APJ''s record in field 'workgroup' of table 'empid'.

for example: APJ_CN

                   APJ_JP

                   APJ_KR ...

thank you!

[ashfaq_haseeb]

Hi try below

sql select * from table

where workgroup like 'APJ%'

at qvd level

load * from table.qvd

where match(workgroup ,'APJ*')

Regards

ASHFAQ

[#3]

goto calculated dimension say

if (widlmatch(empid, "APJ*"), empid) and check the box "Suppress when value is null"

[its_anandrjs]

Update now check few more load script

You can try

In Qlikview Load

Load *

From empid

Where WildMatch(workgroup,'APJ*')

Or

Load *

From empid

Where Match(Left(de,3),'APJ');//If first 3 letters

Or

Load *

From empid

Where  Left(workgroup,3) = 'APJ';

Or

In Front end

IF( WildMatch(workgroup,'APJ*'), empid)

Note:- And suppress when value null option selected.