Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

juriengroot
New Contributor III

Set analysis or IF not equal to any value from dimension

Hi,

I want to compare a column A with values, say value A to all possible values from column B, eventhough they are not related in the same row.

Column AColumn B
AX
BY
BZ
CA
CZ

For this example I want to compare COUNT(IF(Column B <> All possible values of Column A, 1)) This should result in 4.

I cannot find the syntax to compare to unrelated values.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis or IF not equal to any value from dimension

Or this

=Count([Column A]) - Count({<[Column A] = p([Column B])>} [Column A])

2 Replies
MVP
MVP

Re: Set analysis or IF not equal to any value from dimension

May be this

Count({<[Column A] = e([Column B])>} [Column A])

MVP
MVP

Re: Set analysis or IF not equal to any value from dimension

Or this

=Count([Column A]) - Count({<[Column A] = p([Column B])>} [Column A])