topic Re: condition in QlikView

condition

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI ALl

there is a field by name Lead which has the following content

Lead:

abc_dp

abc_dp1

ABC_dp

ABC_WE

Yzx_r

art

bed

sem

...

i want only those which start from abcor ABC content only

to this iam tying to apply this condition

where Lead:='ABC'; after loading this i dont see any content . can someone try to help me out with this

Re: condition

asgardd2 — Fri, 11 Nov 2016 10:04:29 GMT

Hello!

Try using left() and trim() functions.

"...Where Left(trim(Lead),3) = 'ABC' or Left(trim(Lead),3) = 'abc'"

or with match() function:

"...Where Match(Left(trim(Lead),3),'ABC','abc') "

Re: condition

antoniotiman — Fri, 11 Nov 2016 10:05:24 GMT

Hi John,

maybe

LOAD * Inline [
Lead:
abc_dp
abc_dp1
ABC_dp
ABC_WE
Yzx_r
art
bed
sem
]
Where SubField([Lead:],'_',1)='ABC';

Regards,

Antonio

Re: condition

Chanty4u — Fri, 11 Nov 2016 10:05:55 GMT

TRY THIS

Select *

From xxxxxxx

Where lEAD IN ( 'abc*',ABC*');

or you can do it in the preceding load

LOAD *

Where Match(Lead, 'abc*','ABC*');

Select *

FROM xxxxxxx;

Re: condition

Anonymous — Fri, 11 Nov 2016 10:14:48 GMT

Hi John

main_table:LOAD * INLINE [

lead

abc_tp

abc_dp1

ABC_dp

ABC_WE

YZX_r

art

bed

sem

];

min_temp:

load lead as lead_ABC Resident main_table where WildMatch( lead,'ABC*');

excute this you will get field name start with ABC

Re: condition

Chanty4u — Fri, 11 Nov 2016 10:19:44 GMT

orelse try in simple

Data:

LOAD * INLINE [

lead

abc_tp

abc_dp1

ABC_dp

ABC_WE

YZX_r

art

bed

sem

]

Where WildMatch(lead,'ABC*');

Result:

Re: condition

susovan — Fri, 11 Nov 2016 10:25:14 GMT

Also try this,

Lead:

LOAD Lead

FROM

Table.xlsx

(ooxml, embedded labels, table is Sheet1)

Where WildMatch(Lead,'ABC*','abc*')

;

Re: condition

smilingjohn — Fri, 11 Nov 2016 10:29:58 GMT

Hi Chanty it works

Cant i make everythins as capital and get the output .?

all small abc_* should appear in capitals letters

Re: condition

Chanty4u — Fri, 11 Nov 2016 10:32:05 GMT

good

it will work for both

Re: condition

Anonymous — Fri, 11 Nov 2016 10:33:39 GMT

Use Captalise () fuction or upper () function before field name

Re: condition

smilingjohn — Fri, 11 Nov 2016 10:34:00 GMT

But i see both the capital and small letter in the lead list box , i want to have all the small abc* to convert to capital ABC*

I tried like this but it did not work

Where WildMatch(Capitalize(Lead),'ABC*');

Re: condition

smilingjohn — Fri, 11 Nov 2016 10:35:21 GMT

Hi Mahesh

i tried like this but it did not work

Where WildMatch(Capitalize(Lead),'ABC*');

Re: condition

Chanty4u — Fri, 11 Nov 2016 10:37:47 GMT

if you need case sensative search then try with match()

Re: condition

antoniotiman — Fri, 11 Nov 2016 10:39:19 GMT

Try

LOAD Upper([Lead:]) as [Lead:] Inline [
Lead:
abc_dp
abc_dp1
ABC_dp
ABC_WE
Yzx_r
art
bed
sem ]
Where Upper(SubField([Lead:],'_',1))='ABC';

Re: condition

Chanty4u — Fri, 11 Nov 2016 10:40:25 GMT

give a try below

LOAD * INLINE [

lead

abc_tp

abc_dp1

ABC_dp

ABC_WE

YZX_r

art

bed

sem

];

min_temp:

load upper(lead) as lead_ABC Resident main_table where WildMatch( UPPER(lead),'ABC*');