Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi try below
sql select * from table
where workgroup like 'APJ%'
at qvd level
load * from table.qvd
where match(workgroup ,'APJ*')
Regards
ASHFAQ
goto calculated dimension say
if (widlmatch(empid, "APJ*"), empid) and check the box "Suppress when value is null"
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.