topic Labels on drill down in App Development

Labels on drill down

johnpaul — Tue, 04 Nov 2014 01:33:23 GMT

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.

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?

Re: Labels on drill down

JonnyPoole — Fri, 07 Nov 2014 01:34:58 GMT

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.

Re: Labels on drill down

jasmina_karcic — Sun, 21 Jul 2019 10:11:45 GMT

Is anything changed aobut this? 😕

Thanks,

Jasmina

Re: Labels on drill down

subhransu143 — Fri, 05 Jun 2020 16:47:31 GMT

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

Re: Labels on drill down

sonal_ag — Tue, 11 Aug 2020 10:16:17 GMT

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 .