topic Selecting Multiple criteria on same field in Set Expressions in QlikView

Selecting Multiple criteria on same field in Set Expressions

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

Hi Everyone

I am trying to get 2 different subsets of data off of the same field and need help with the logic within the set expression

What I am Wanting to get is

Column A = 1 and Column B = 2, 3, or 4 OR Column A = 2

Currently the set expression can give me Column A = 1 or 2 and Column B = 2,3,or 4, but I want data for Column A= 2 and Column B = 1,2,3,4,5,6

count( {< ColumnA = {"1","2"}, ColumnB = {"2","3","4"}>} distinct ColumnC)

sunny_talwar — Thu, 16 Nov 2017 17:55:24 GMT

May be this

Count(DISTINCT {<ColumnA = {1}, ColumnB = {2, 3, 4}>+<ColumnA = {2}>} ColumnC)

sunny_talwar — Thu, 16 Nov 2017 17:56:37 GMT

Or this

Count(DISTINCT {<ColumnA = {1}, ColumnB = {2, 3, 4}>+<ColumnA = {2}, ColumnB = {1, 2, 3, 4, 5, 6}>} ColumnC)