Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
abhi1693r
Contributor II
Contributor II

Counting columns with exception

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.

6 Replies
dplr-rn
Partner - Master III
Partner - Master III

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)

abhi1693r
Contributor II
Contributor II
Author

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.

dplr-rn
Partner - Master III
Partner - Master III

did you try

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

abhi1693r
Contributor II
Contributor II
Author

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

abhi1693r
Contributor II
Contributor II
Author

 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.

Brett_Bleess
Former Employee
Former Employee

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.