How to Custom Drilldown Labels

[#1]

Hi

I've created a drill down with  Calculated Dimensions, How Can I customize the label for each Dimension inside drill down?

For Instance:

Data load :

CONTRABAND:

LOAD * INLINE [

Name,Quantity

CellPhone,10

CellPhone,20

Cellphone Charger,50

SIM Card, 10

COCAINE, 5

ECSTACY, 10

HEROINE, 2

MARIJUANA,3

];

Drill down :

when I use the drill down in the Bar chart :  the Title of X-axis and Legend show the formula , How can I change the labels ?

thanks! !

[sunny_talwar]

Why don't you create the new field in the script?

CONTRABAND:

LOAD * INLINE [

Name,Quantity

CellPhone,10

CellPhone,20

Cellphone Charger,50

SIM Card, 10

COCAINE, 5

ECSTACY, 10

HEROINE, 2

MARIJUANA,3

];

LinkTable:

LOAD Name,

  if(Mixmatch(Name,'CellPhone','Cellphone Charger','SIM Card'),'Cell Phone',

  if(Mixmatch(Name,'COCAINE','ECSTACY','HEROINE','MARIJUANA'),'Drugs'

    ,'Others')) as Category

Resident CONTRABAND;

And now you can use Category as a dimension instead of using the If(MixMatch(...)

[#3]

Hi 

Thanks for your quickly response .

to create a new filed in LOAD Scripts is  a great workaround for this issue,

but I am looking forward a new way for users to create group when they create their own dimensions.

For Instance,  By Age group ,some users use 10 years age group, some might use 5 years age group ,or someone else will use under 17 as Juvenile, and for those older than 17 will use 5 years age group.

[#4]

you can refer below link to get idea but not sure if it works in Qlik Sense also.

Dynamic Labels

[sonal_ag]

aggr(if(rank(sum({<$(vCommonFilter2)>} [Gross Margin]*[Conversion Rate]))<=5,[Customer Name]),[Customer Name])

how to rename this condition as i have created this in calculated dimension, so i want to rename the dimension.