Solved: Re: help with calculated dimension expression - Qlik Community

arusanah · ‎2016-08-22

=if(not match(MCO,'New *'),MCO)

trying to eliminate values in dimension that starts with "New". tried lot of expresions but not working .. pls help

effinty2112 · ‎2016-08-23

Hi Archana,

In the definition of your calculated dimension you'll need to use an aggr function like this:

=aggr(if(not wildmatch(MCO,'New *'),MCO),MCO)

Cheers

Andrew

View solution in original post

Anil_Babu_Samineni · ‎2016-08-22

If you want to exclude where start the name new space any string. I have deleted the space from below expression.

This expression seems right to exclude the value or why not scripting

=if(not match(MCO,'New*'),MCO)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Report Inappropriate Content · ‎2016-08-23

Hi Archana,

Try below script:

=if(not wildmatch(MCO,'New '),MCO)

Thanks.

arulsettu · ‎2016-08-23

try this

if(not match(MCO,'New'),MCO)

jonathandienst · ‎2016-08-23

Match is for an exact match - you need WildMatch for a wildcard:

=If(Not(WildMatch(MCO, 'New*')), MCO)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Chanty4u · ‎2016-08-23

try below

=If(Not(WildMatch(MCO, '*New*'))),MCO)

Chanty4u · ‎2016-08-23

or

If(MCO NOT LIKE 'New*', MCO)

ramchalla · ‎2016-08-23

Hi Archana,

You can use the expression as Jonathan suggested.

=If(Not(WildMatch(MCO, 'New*')), MCO)

yasmeenk · ‎2016-08-23

Hi Archana,

Try this,

=if(not(WildMatch(MCO,'New*')),MCO)

Anonymous · ‎2016-08-23

Hi Archana,

Try this: IF(LEFT(UPPER(TRIM(MCO)),3)<>'NEW',MCO)

Regards!

help with calculated dimension expression

QlikView App Dev