Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
AIShatiLove
Contributor III
Contributor III

count values in pivot table with set analysis

 Continuance of the question  https://community.qlik.com/t5/New-to-Qlik-Sense/Compare-fields-and-count/m-p/1787486#M180521
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