topic Re: Label on a calculated dimension in Visualization and Usability

Label on a calculated dimension

Tue, 26 Aug 2014 10:48:48 GMT

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

Re: Label on a calculated dimension

Michael_Tarallo — Tue, 26 Aug 2014 12:55:27 GMT

Hi Jens,

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

Re: Label on a calculated dimension

Tue, 26 Aug 2014 13:15:40 GMT

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

Re: Label on a calculated dimension

Michael_Tarallo — Tue, 26 Aug 2014 13:25:40 GMT

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

Re: Re: Label on a calculated dimension

Michael_Tarallo — Tue, 26 Aug 2014 13:28:27 GMT

See attached .mp4 video for clarity

Re: Label on a calculated dimension

Tue, 26 Aug 2014 13:29:02 GMT

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

Re: Label on a calculated dimension

Michael_Tarallo — Tue, 26 Aug 2014 13:46:06 GMT

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