Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

count values in pivot table with set analysis

 Continuance of the question
here is an expression, but it counts incorrectly  : its should be 1 not 3
 =If(Sum(Aggr(If(Match([field1.Table1], [field1.Table2]), 1, 0), [field1.Table1], [field1.Table2])) > 0, count({<[field1.Table1]-={[field1.Table2]}>} distinct FieldForValue.Table2),'Not come')


it counts FieldForValue.Table2 but i need that i counts only values that are not equal to "Not come"

Labels (1)
0 Replies