topic Re: Expression in script in QlikView

Expression in script

Mon, 17 Aug 2015 15:13:54 GMT

Hi,

can anybody change the given expression and give me the same in scripting part. but want the count of matched and unmatched rows...

EXP:::

IF(IsNull(TRIM(Company_NM))

,If(UPPER(Trim([BU_SORT1]))<>UPPER(TRIM(LEFT([Common_NM],20))),'NO MATCH','MATCH')

,If(UPPER(Trim([BU_SORT1]))<>UPPER(TRIM(LEFT([Company_NM],20))),'NO MATCH','MATCH')

)

i want this to code in script but want to rename as matched and unmatched with sum

like sum(if(BU_SORT1=Common_NM),1,0) as matched

sum(if(BU_SORT1<>Common_NM),1,0) as unmatched

with the given conditions

I am trying but showing error as: multiple parameters..

Pls help

Re: Expression in script

jagan — Mon, 17 Aug 2015 15:31:17 GMT

HI,

Try like this

sum(if(BU_SORT1=Common_NM,1,0)) as matched ,

sum(if(BU_SORT1<>Common_NM,1,0)) as unmatched

Regards,

Jagan.

Re: Expression in script

Mon, 17 Aug 2015 15:34:22 GMT

Try like below:

Add the Flag to yuur scipt:

if( Len(Tirm(Company_NM) ,

if( upper(Trim(BU_SORT1)) = UPPER(LEFT(TRIM(Common_NM),20)) , 1 ,1 )

,0 ) AS MatchFlag

MatchFlag have 1 for match 2 for nomatch 0 for null

UI:

Counr({<MatchFlag={1}>} DISTINCTCompany_NM) --> Match Flag count

Counr({<MatchFlag={2}>} DISTINCTCompany_NM) --> NoMatch Flag count

Re: Expression in script

Mon, 17 Aug 2015 15:42:48 GMT

I want them to show in the table box ,so dont want to do anything in the UI side.No falgs works out

Re: Expression in script

Mon, 17 Aug 2015 16:41:03 GMT

If you need the field shows on the table box, simply convert number into text.

if( Len(Tirm(Company_NM) ,

if( upper(Trim(BU_SORT1)) = UPPER(LEFT(TRIM(Common_NM),20)) , 'Match' ,'NoMatch' )

,null() ) AS IsMatch

Re: Expression in script

Mon, 17 Aug 2015 17:06:56 GMT

Dathu, I didn't get you. can you clear me.

Re: Expression in script

Mon, 17 Aug 2015 17:26:33 GMT

can any body help pls