How to Hide Helper Measure Column Without Affecting Row Filtering Logic
I have implemented a helper measure in a Qlik Sense straight table to ensure that only relevant rows are displayed based on user interaction. The filtering logic is working as expected, but because the measure is included in the table, it is being displayed as an additional column. As per client requirement, no extra/helper column should be visible.
Could you please suggest whether it is possible to hide the measure column while still keeping the measure logic active for row filtering?
In QlikView there was an appropriate option within the object-properties to hide certain columns. Maybe this kind of feature is further exists in Sense.
Beside of this - the logic might be implemented within each measure or within any of the dimensions by using a calculated dimension.
I tried moving the row-filtering logic into a calculated dimension as suggested. However, since the logic contains aggregation functions (such as Count() and set-based expressions), it results in an “Invalid dimension” error in Qlik Sense.
Calculated dimensions in Qlik are required to operate at row level and do not support complex aggregation-based conditions like measures do.
If aggregations are applied within a calculated dimension it needs to be to wrap the logic within an aggr() to define a dimensional context. Such approach may look like:
aggr(if(count({ Set } MyField) > n, MyDim1), MyDim1, MyDim2)
