Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
aha, not bad,
can I somehow hide that field from table?
It doesn't work btw.. 😕