topic Re: Counting columns with exception in QlikView

Counting columns with exception

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

Hi,

I am counting 2 columns A and B, Count( DISTINCT A&'|'&B)

I want to exclude any cells with the word "ROM".

Please help.

Re: Counting columns with exception

dplr-rn — Wed, 17 Jul 2019 21:51:18 GMT

Which is the column with value 'ROM'?

guessing there is more to it that this suggestion but did you try set analysis

Count( DISTINCT {<Cell-={'ROM'}>} A&'|'&B)

Re: Counting columns with exception

abhi1693r — Thu, 18 Jul 2019 13:39:38 GMT

ROM is present in column C, Also ROM is a prefix word of the entire text present in the cell. I want to take out all the cells with ROM.

Re: Counting columns with exception

dplr-rn — Thu, 18 Jul 2019 13:55:36 GMT

did you try

Count( DISTINCT {<C-={'ROM'}>} A&'|'&B)

Re: Counting columns with exception

abhi1693r — Thu, 18 Jul 2019 14:20:06 GMT

I did try, The result is same as Count( DISTINCT INFOCUBE&'|'&PARTCUBE)

Re: Counting columns with exception

abhi1693r — Mon, 29 Jul 2019 13:12:33 GMT

I just noticed that I am not getting all the 'ROM' rows excluded. Is there any other way to solve this. I can share the exact problem if you like.

Re: Counting columns with exception

Brett_Bleess — Mon, 12 Aug 2019 18:15:08 GMT

Given you have received no further posts, I would say it would be good to add the additional information and perhaps an example app if possible as well, sometimes that makes things the end objective easier to grasp and will result in a quicker potential solution...

Set analysis does seem to be the right avenue here though, so here are a couple of links with more info that might help:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Note, there is a link at the end of that post to one regarding excluding values....

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Regards,
Brett