Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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.
did you try
Count( DISTINCT {<C-={'ROM'}>} A&'|'&B)
I did try, The result is same as Count( DISTINCT INFOCUBE&'|'&PARTCUBE)
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.
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....
Regards,
Brett