Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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