Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

help with calculated dimension expression

=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

1 Solution

Accepted Solutions
effinty2112
Master
Master

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

10 Replies
Anil_Babu_Samineni

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
Not applicable

Hi Archana,

Try below script:

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


Thanks.

arulsettu
Master III
Master III

try this

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

jonathandienst
Partner - Champion III
Partner - Champion III

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
MVP
MVP

try below

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

Chanty4u
MVP
MVP

or

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

ramchalla
Creator
Creator

Hi Archana,

You can use the expression as Jonathan suggested.

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

yasmeenk
Partner - Creator
Partner - Creator

Hi Archana,

Try this,

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



Anonymous
Not applicable

Hi Archana,

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

Regards!