Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Partner

master dimension is the only way afik

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

Hi,

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