topic Re: Lock Filter in Selection in App Development

Lock Filter in Selection

ena1309 — Wed, 25 May 2022 08:00:50 GMT

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

Re: Lock Filter in Selection

justISO — Wed, 25 May 2022 10:21:15 GMT

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)

Re: Lock Filter in Selection

ena1309 — Wed, 25 May 2022 10:44:13 GMT

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

Re: Lock Filter in Selection

ena1309 — Thu, 02 Jun 2022 14:16:06 GMT

It doesn't work btw.. 😕