topic Re: help with calculated dimension expression in QlikView

help with calculated dimension expression

arusanah — Mon, 22 Aug 2016 22:57:36 GMT

=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

Re: help with calculated dimension expression

Anil_Babu_Samineni — Tue, 23 Aug 2016 03:51:06 GMT

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)

Re: help with calculated dimension expression

Tue, 23 Aug 2016 04:35:28 GMT

Hi Archana,

Try below script:

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

Thanks.

Re: help with calculated dimension expression

arulsettu — Tue, 23 Aug 2016 04:37:51 GMT

try this

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

Re: help with calculated dimension expression

jonathandienst — Tue, 23 Aug 2016 04:58:11 GMT

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

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

Re: help with calculated dimension expression

Chanty4u — Tue, 23 Aug 2016 05:10:16 GMT

try below

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

Re: help with calculated dimension expression

Chanty4u — Tue, 23 Aug 2016 05:20:15 GMT

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

Re: help with calculated dimension expression

ramchalla — Tue, 23 Aug 2016 05:51:42 GMT

Hi Archana,

You can use the expression as Jonathan suggested.

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

Re: help with calculated dimension expression

yasmeenk — Tue, 23 Aug 2016 06:01:55 GMT

Hi Archana,

Try this,

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

Re: help with calculated dimension expression

Anonymous — Tue, 23 Aug 2016 06:11:18 GMT

Hi Archana,

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

Regards!

Re: help with calculated dimension expression

effinty2112 — Tue, 23 Aug 2016 07:18:16 GMT

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