Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
shephali23
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
dilipranjith
Partner
Partner

master dimension is the only way afik

AlbertoV
Partner
Partner

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

Vegar
MVP
MVP

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
jaimeaguilar
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