topic Re: how to set filter? in QlikView

how to set filter?

Thu, 26 Jun 2014 06:41:54 GMT

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 — Thu, 26 Jun 2014 06:45:14 GMT

Hi try below

sql select * from table

where workgroup like 'APJ%'

at qvd level

load * from table.qvd

where match(workgroup ,'APJ*')

Regards

ASHFAQ

Thu, 26 Jun 2014 06:47:04 GMT

goto calculated dimension say

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

its_anandrjs — Thu, 26 Jun 2014 06:49:02 GMT

Update now check few more load script

You can try

In Qlikview Load

Load *

From empid

Where WildMatch(workgroup,'APJ*')

Load *

From empid

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

Load *

From empid

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

In Front end

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

Note:- And suppress when value null option selected.