topic Re: Exclude multiple words form 'COUNT' in QlikView

Exclude multiple words form 'COUNT'

Mon, 26 Jan 2026 16:26:21 GMT

I want to exclude two definitions of 'COUNT'. Probably not so complicated, but I do not get it done. One exclusion works fine, a second exclusion unfortunately not.

What I would like to exclude: << choose from list >> and '...'

The expression I use:

Count ({$ <[Type or funtion] - = {"<< >> choose from list"}>} {$ <[Type of funtion] - = {"..."}>} [Type of funtion]) /

Count (TOTAL <Corporatie> {$ <[Type of funtion] - = {"<< >> choose from list"}>} {$ <[Type of funtion] - = {"..."}>} [Type of funtion])

Or: how to select only predefined textstrings in 'COUNT'

Re: Exclude multiple words form 'COUNT'

venkatg6759 — Wed, 21 May 2014 14:59:31 GMT

Try this

aggr(Count ({$ <[Type or funtion] - = {'<< >> choose from list','...'>} [Type of funtion]),[Type of funtion])

Re: Exclude multiple words form 'COUNT'

alexandros17 — Wed, 21 May 2014 14:59:40 GMT

Count ({$ <[Type or funtion] = {'*'} - {"<< >> choose from list","..."}>} [Type of funtion])

....

Let me know

Re: Exclude multiple words form 'COUNT'

Wed, 21 May 2014 15:27:43 GMT

Like this?

aggr(Count ({$ <[Type or function] - = {'<<choose from list>>','...'>} [Type of function]),[Type of function]) /

aggr(Count (TOTAL <Organization> ({$ <[Type or function] - = {'<<choose from list>>','...'>} [Type of function]),[Type of function])

Probably not, since it doesn't work...

Re: Exclude multiple words form 'COUNT'

alexandros17 — Wed, 21 May 2014 15:31:53 GMT

I don't know about aggr because I don't know data but

aggr(Count ({$ <[Type or function] - = {'<<choose from list>>','...'}>} [Type of function]) /

aggr(Count (TOTAL <Organization> ({$ <[Type or function] - = {'<<choose from list>>','...'}>} [Type of function])

Let me know

Re: Exclude multiple words form 'COUNT'

SunilChauhan — Wed, 21 May 2014 15:49:10 GMT

you can change only below in expression

[Type or function] - = {'listvalue1','listvalue2','listvalue3'}

you can even exclude more you want by comma sepeareted as above

hope this helps

Re: Exclude multiple words form 'COUNT'

Mon, 26 May 2014 19:20:08 GMT

The tips given work, thanks... but on second thoughts I find it more convenient to configure the load script. After some research:

The dimension that you want to exclude of certain values:

[dimension]

FROM '$ (SOURCE) "(OOXML, embedded labels, table is [NAME TABLE]

Where [dimension] <> 'value to exclude' AND [dimension] <> 'value to exclude';