Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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
dplr-rn
Partner - Master III
Partner - Master III

master dimension is the only way afik

albertovarela
Partner - Specialist
Partner - Specialist

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)

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

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