Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Zaidan_as
Creator
Creator

Disable filter from dimension in table

As i mentioned in the subject, i want disable the first dimension in my table from selecting a filter.
The table and the disabled dimension is like this

Zaidan_as_0-1648803445905.png

The reason I wanted to disable it because I use "Above" formula in O/B and Outstanding column. 

Is there any solution ?

Labels (6)
2 Replies
OmarBenSalem
Partner - Champion II
Partner - Champion II

2 ways : 

1) The hard way : you change your above expression to not change no matter so selection : a combo of aggr and {1}

2) You create ur date field as a measure not a dimension : aggr(only(date),date) => no filter possible

Zaidan_as
Creator
Creator
Author

sorry for late response,

for the first solution, 
How do I change my code, is it like this 
=Sum(InVal) to =Sum({1}aggr(InVal))

for the second solution,
the result is still the same. The table still changed