Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Custom Drilldown Labels

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 :

drilldown.PNG

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 ?

barchart.PNG

thanks! !

4 Replies
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(...)

Not applicable
Author

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.

Not applicable
Author

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

Dynamic Labels

sonal_ag
Contributor
Contributor

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.