# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for
Did you mean:
Highlighted
Contributor III

## Add text 'YTD' in fiscal year

Hi Guys,

I have a bar graph where I need to add 'YTD' at the end of the fiscal year: it should be something like 'FY20 YTD'. See attached screenshot of the bar graph.

Labels (5)

• ### Year to Date

1 Solution

Accepted Solutions
Highlighted

Perhaps a calculated dimension, something like:

=FiscalYear & If(FiscalYear = MaxString(TOTAL FiscalYear), ' YTD', '')

Replace FiscalYear with the correct field name.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
7 Replies
Highlighted
Partner

Click on the dropdown at your chart properties Fiscal Year Dimension.

At field, click on the fx and try this:

Highlighted
Contributor III

It shows YTD for all the fiscal years.

Highlighted
Partner

Hi

use this in your dimension field

=[Fiscal Year]& ' YTD'

thanks

Highlighted
Contributor III

It shows YTD for all fiscal years. I am looking to show YTD only for FY20 and not for others

Highlighted

Perhaps a calculated dimension, something like:

=FiscalYear & If(FiscalYear = MaxString(TOTAL FiscalYear), ' YTD', '')

Replace FiscalYear with the correct field name.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor III

FANTASTIC!!. Thanks a ton!

Highlighted
Partner

=If(Year='2019',Year&' YTD',Year)