Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Selection shows calculation in dimension

When using formula in dimension, upon selection of the dimension, the selection area shows the formula.

How can it be changed to not show the formula rather the individual component of formula? Using a master dimension solves this but looking for alternatives where in I dont have to create a master dimension or change the formula

Labels (1)
4 Replies
Partner - Master III
Partner - Master III

master dimension is the only way afik

Partner - Specialist
Partner - Specialist

or load the calculated dimension via the data load editor or data manager.


Some expressions can be hidden by creating a dimension front end. 

As an example the dimesion expression below will display as just Username when a selection is done.

=aggr( if(
left(only({1}[Admin_type]),3)='Adm', only({1}Username)), Username)


(I believe it is the Aggr() by dimension that is the key of this behaviour)

Partner - Specialist II
Partner - Specialist II


Using aggr() for your calculated dimension will definitely hide the expression/formula. For example if your calculated dimension is something like  --> if(field1 = 'A', 'value1', 'value2'), then you just have to enclose your original expression with aggr and use your original dimension as your sort/summarize field:


aggr( if(field1 = 'A', 'value1', 'value2'), field1) so Qlik sense will perform an indirect selection. In other words, every time you make a selection in your calculated dimension, you'll see field1 values in the selections bar, instead of the calculated dimension.

You can check the attached example for your reference,


I hope this helps