Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
stantrolav
Partner - Creator II
Partner - Creator II

How to get (show) label of calculated dimension in textbox?

Hi..

I have 2 calculated dimensions in some chart.

1. =Aggr(If(Rank(Sum(PUB_EU))<=5 or ProductName = 'LERKAMEN' or ProductName = 'ZANIDIP-RECORDATI' , ProductName, 'Others...'),  ProductName)

2. =Aggr(If(Rank(Sum(PUB_EU))<=5 or ProductName = 'LERKAMEN' or ProductName = 'ZANIDIP-RECORDATI', Mol_Desc1, 'Others...'),  Mol_Desc1)

They have labels:

1. Product

2. Molecule

They are in cyclic group named

MainGroup

When i use function GetFieldSelections(MainGroup) there is nothing in my textbox.

But when i use straight dimensions like this without any calculation:

1. ProductName

2. Mol_Desc1

With the same labels written above, I get names of my dimensions: ProductName or Mol_Desc1. But not the labels that I defined for every of them. Is there some function to show Labels?

1 Solution

Accepted Solutions
Anonymous
Not applicable

1 Reply
Anonymous
Not applicable

11