Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude multiple words form 'COUNT'

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'

1 Solution

Accepted Solutions
Not applicable
Author

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';

View solution in original post

6 Replies
venkatg6759
Creator III
Creator III

Try this

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

alexandros17
Partner - Champion III
Partner - Champion III

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

....


Let me know

Not applicable
Author

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

alexandros17
Partner - Champion III
Partner - Champion III

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

SunilChauhan
Champion
Champion

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


Sunil Chauhan
Not applicable
Author

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';