Label on a calculated dimension

[#1]

Hello!

I can not find a way to put a label on a calculated dimension. My dimension, which is a text string that is calculated according to the following formula:

If(Right(Aktivitetsbeskrivning, Len(Aktivitetsbeskrivning) - 5) <> 'Projektaktivitet', Aktivitetsbeskrivning, Null())

Now it is not possible to put a label on the calculated dimension (se enclosed image). This string operation could of course be executed in the script instead by creating a new field with the calculated value.

Is it possible to label a calculated dimension in QlikSense?

Thanks.

Jens

[Michael_Tarallo]

Hi Jens,

When you click and type in the box what happens? I am able to label this.

[#3]

Hello Michael!

Thanks for your reply.

The "cursor" gets stuck to the very left in the "Label" box. When I try to move it or mark the text with the mouse pointer or any arrow key, nothing happens. It is still stuck to the very left in the box. No matter if use just the arrow keys or <Shift> arrow keys.

Text font colour in the "Label" box is also slightly lighter than in the "Field" box and that might indicate that it is not possible to edit that field.

Regards

Jens

[Michael_Tarallo · Accepted solution]

Hi Jens - did you try just typing over it? - that very light-grey text is just a placeholder, it is more of a background to show what the default value will be unless you type over it - it is not meant to be selected with the mouse. You should be able to click in the box and start typing over it. Let me know if that works,

If that does not work, then try this:

• Open a web browser
• access http://localhost:4848/hub
• Go to your app and see if you can edit / insert the label there.

I am trying to determine if it is the Desktop interface that might be causing the problem.

Mike

[Michael_Tarallo]

See attached .mp4 video for clarity

[#6]

Hello again!

That worked OK. I don't understand why I didn't try that in the first place.

I have to add a comment on this matter:

It solved the problem just typing over it. But when I tried that again – strangely enough – I had to type a letter at least twice to get rid of the "default text" in the box. After that, everything worked perfect.

Thanks.

Regards

Jens

[Michael_Tarallo]

Perfect - please mark which reply helped you so we can mark this one as answered.

Have fun with Sense and let us know how else we can help.

Mike