Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
In Your dimension put
=aggr(
if(
Expression_1 <> Expression_2
,Dimension)
,Dimension)
Need to remove Flag from "include null Values"
regards
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
cool, I'm glad to hear that you have helped