Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
JAN. 24, Q&A with Qlik: Making the Move to Qlik Cloud Reporting: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
johnpaul
Partner - Creator
Partner - Creator

Labels on drill down

With QlikView, when you build a dimension drill down, you can set the name for the column at each level.

With Sense, there doesn't seem a way to do this.

2014-11-04_11-59-30.png

This is a problem if you use a function to show or hide the column.

Anyone worked out a work-around, or am I missing something?

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

There is not within the drill down dimension definition. 

You would need to create those calculated dimensions in the load editor where you can do aliases.

For example, in the load editor

change:

Load

     Project_Name,

     Phase_Name,

     ....

To:

Load

     Project_Name as [Project Name],

     Phase_Name as [Phase Name],

     if(PMStatus='Open',Company......      as [New Field Name],

....

Once you make the change, hit 'load',  then back in the UI you will have 'Project Name' , 'Phase Name', and 'New Field Name' as nice clean dimensions for your drill down dimension.

View solution in original post

4 Replies
JonnyPoole
Employee
Employee

There is not within the drill down dimension definition. 

You would need to create those calculated dimensions in the load editor where you can do aliases.

For example, in the load editor

change:

Load

     Project_Name,

     Phase_Name,

     ....

To:

Load

     Project_Name as [Project Name],

     Phase_Name as [Phase Name],

     if(PMStatus='Open',Company......      as [New Field Name],

....

Once you make the change, hit 'load',  then back in the UI you will have 'Project Name' , 'Phase Name', and 'New Field Name' as nice clean dimensions for your drill down dimension.

jasmina_karcic
Creator III
Creator III

Is anything changed aobut this? 😕

 

Thanks,

Jasmina

subhransu143
Partner - Contributor
Partner - Contributor

Can it be managed in front end by creating some calculation ? 

sonal_ag
Contributor
Contributor

aggr(if(rank(sum({<$(vCommonFilter2)>} [Gross Margin]*[Conversion Rate]))<=5,[Customer Name]),[Customer Name])
how to write this expression in script to rename the calculated dimension .