Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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