topic Re: Dynamic label field based on a variable in App Development

Dynamic label field based on a variable

Rick_T — Thu, 23 Dec 2021 18:28:44 GMT

Hello everyone,

I made a variable which serves as a input for a specific month. So when i click on a month the visuals adapt and show the data of the selected month. So far so good. Now I am trying to achieve the same dynamic ability with the label of the dimension c.q. measure.

I am using the following expression:

='Omzet'&' '&date(vMaand, 'MMMM') &' '&vJaarVorig

The green part works fine but I can't get the red part to work together with the selected variable. When I only use the vMaand variable without the date(......, 'MMMM') it works but it shows a short month name notation. I want it to show the full month name. Does anyone know how I can achieve this?

Sincerely,

Rick

Re: Dynamic label field based on a variable

jmartineze — Fri, 23 Aug 2019 10:37:06 GMT

Hello Rick,

the month name it depends on your variables in the begin on the script, you must change it.

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

change by

SET MonthNames='January;February; etc...

Re: Dynamic label field based on a variable

Rick_T — Fri, 23 Aug 2019 10:43:01 GMT

Hello J,

Thanks for your quick and helpful reply. This will be my final option because right now my whole dashboard is build upon the short variable names. If I change these I will have to check every expression I made. Normally I can work around this by changing the short month names with long ones by 'MMMM' in the expression, but this is not possible in the way I try it now?

Sincerely,

Rick

Re: Dynamic label field based on a variable

jmartineze — Fri, 23 Aug 2019 10:56:45 GMT

Try change it in the number tabs, select dimension,press formar settings Date option and add MMMM in the format pattern box.

Re: Dynamic label field based on a variable

Rick_T — Fri, 23 Aug 2019 10:59:24 GMT

Hi J,

Found the error, I needed to format the actual short month name in the set expression correctly.

Used 'MMM' right now but all the short month names are formatted with a dot at the end so 'MMM.' was the correct way.

Thanks for your replies.

Sincerely,

Rick