topic Re: Removing a Prefixed word from Expression in QlikView

Removing a Prefixed word from Expression

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

Hello,

I need to remove everything with "BBDC" from a query, as I need to pick up everything that don't start with "BBDC" in a pivot.

Currently tried this and few other however not working.

=count({<[Exception ID],[Case Sub team]-={"BBDC*"}>}[Exception ID])

Example list below

BBDC London

BBDC East

BBDC West

BBDC South

London

East

West

North

South

Any help with be appreciated.

Thanks

Mohi

Re: Removing a Prefixed word from Expression

Anonymous — Mon, 24 Sep 2018 13:20:34 GMT

not sure what you want

if you want to exclude Sub Teams starting with BBDC I would use a calculated dimension

if ((left([case Sub Team],4)<> 'BBDC', [Case Sub Team])

if you want to Report BBDC London to London I would use calcualted Dimension like

if ((left(case Sub Team,4) = 'BBDC', mid(case Sub Team,5, 10), case Sub Team)

your Expression would be

count(Exception ID)

Re: Removing a Prefixed word from Expression

timpoismans — Mon, 24 Sep 2018 13:37:18 GMT

From what I can understand, and based on your own measure that you tried, you want to count the Exception ID's of all the Case Sub Teams that don't start with BBDC.

You should try this then:

Count({<[Case Sub Team]=-{'BBDC*'}>}[Exception ID])

Left is a table with random generated Exception ID's, right is a table with my measure.

Re: Removing a Prefixed word from Expression

prieper — Mon, 24 Sep 2018 15:16:24 GMT

think, it should be minus followed by the equal:

Count({<[Case Sub Team] -= {'BBDC*'}>}[Exception ID])

Re: Removing a Prefixed word from Expression

vishsaggi — Mon, 24 Sep 2018 15:53:41 GMT

may be this?

= count(IF( Not Wildmatch([Case Sub team], 'BBDC*')>0, [Exception ID])

Re: Removing a Prefixed word from Expression

timpoismans — Tue, 25 Sep 2018 06:14:15 GMT

Purely depends on if he wants to make further selections in Case Sub Team or really wants to show all the Case Sub Teams that don't start with BBDC all the time.

=- doesn't take any further selections in Case Sub Team into account

-= does take further selections in Case Sub Team into account

Re: Removing a Prefixed word from Expression

sasiparupudi1 — Tue, 25 Sep 2018 10:20:04 GMT

May be try

count({1<[Case Sub team]-={"BBDC*"}>}[Exception ID])