Lock Filter in Selection

[ena1309]

Hi guys, 

When i open a sheet in Qlik Sense i would like it to be filtered, i found on actions- lock filter (i saved filter as a bookmark, then i perfomed it)
but how to do that on measured field (sum[field_name)]

i have vizLib Table Chart as in picture
and i want one column to filter ALWAYS <>0

thank you

[justISO]

Hi, one workaround solution I can suggest is to create separate 'flag' from measure-converted-to-dimension field, like

if(aggr(sum([Adjustment Quantity]), [Material Description]) >0, 1,0)

[ena1309]

aha, not bad, 
can I somehow hide that field from table?

[ena1309]

It doesn't work btw.. 😕