Compare fields and count matches

[AIShatiLove]

Hi, qlik

I want to exlude some records in set analysis for my pivot table : if  field1.Table1 != field1.Table2  and count count the remaining values

[Chanty4u]

Hi

here you can find different ways to exclude .

https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704

one example here

https://community.qlik.com/t5/QlikView-App-Dev/Set-Analysis-To-exclude-an-item/td-p/444439

[AIShatiLove]

I tried to follow the example, but it does not work as it should 
what i have : count( {  $< Filed1.Table1 = { Field1.Table2 }  >  } distinct Field_of_Values)  it returns me nothing
what am i missing ?

[Chanty4u]

what is the inside values  for   Field1.Table1 and  Field1.Table2  ?

 count( {  $< Filed1.Table1 = { "Field1.Table2" }  >  } distinct Field_of_Values) 

[AIShatiLove]

there are intersecting  values( numbers) in these columns, and conditions is : if there common values in this fileds  then count 

[Chanty4u]

can you paste some sample data and expected output for better output.

[AIShatiLove]

I used to use this expression: if ( [filed1.Table1]= [ field1.Table2 ],count ( field_of_values.Table2 ),Null())
Here's what I got ,  my main goal was to remove unnecessary dashes and the values that have them,  and that's why  decided to use set analysis

[Chanty4u]

did you tried supress null values option?

[AIShatiLove]

yes, of course, all dimensions do not include null
because of these omissions, I can not get sum by the name of the position, in the end I get just a dash in table

I need to build a set analysis expression to get only the desired values. I think then this problem will go away

[AIShatiLove]

i found solution in this post . Instead of output, it should just count

https://community.qlik.com/t5/QlikView-App-Dev/comparing-two-column/td-p/1108079