Qlik Community

Qlik Sense App Development

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

kamil_stachowic
New Contributor

Display label instead of var name on Drill Dimension

Hello everyone

I got a Drill Down Dimension which consists of 3 single dimensions:

- ALLOCATION_YEAR (as yyyy),

- ALLOCATION_YM (as yyyy-MM)

- $(v_alloc_date)

Last one is based on dimension ALLOCATION_DATE (as dd.MM.yyyy hh:mm:ss)

I already did Trunc on ALLOCATION_DATE to get rid of Timestamp but field still carries time 00:00:00 so i created a variable v_alloc_date with formula Date(ALLOCATION_DATE,'dd.MM.yyyy')

Now I would like to show on 3rd level not the variable name but some label like 'Allocation Date' or something nice looking.

Is there any way to fix it?

QS_drill_name.png

2 Replies
undergrinder
Valued Contributor II

Re: Display label instead of var name on Drill Dimension

Hi Kamil,

It is so ugly. The label refer to the data model fields. I had same issue, but I can't find the thread.

The v_alloc_date variable convert to column in load script, then the labels will be shown as right.

G.

kamil_stachowic
New Contributor

Re: Display label instead of var name on Drill Dimension

I tried that but when I use Date in load scrip I got an error so i need to do this as I'm doing it now :/