Dont show zero values and "filter" the table not only put "-"

[edupitel7]

I have done a variation table with projects ID and delta values, I only want to show in my tabel values <> 0
I have tried if expression already, but it give me "-" signal and show all values
When i filter in excel this column it shows only several lines and classify by rank of values correctly
Qlik is showing all table lines, and not classifying in rank order correctly

I want a filter to click and "resize" my table like excel filters do

my delta expression is column(3)-column(2)

I don't know if only creating a variable could fix this error

I have done already some searches about "filter by measure" "don't show null values"

But Qlik don't want to resize my table and show only the values <>0 in a rank order

[Yoshidaqlik]

Hi

In Your dimension put

=aggr(
  if(
    	Expression_1 <> Expression_2
  ,Dimension)
,Dimension)

Need to remove Flag from "include null Values"

regards

[edupitel7]

Thks man this works 😄
I have a low experience already with aggr function, I am watching your youtube videos, it helps so much

Thank you

[Yoshidaqlik]

cool, I'm glad to hear that you have helped