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.

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