Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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.

Can anyone advise?

 

 

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

View solution in original post

7 Replies
Highlighted
Partner
Partner

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

At field, click on the fx and try this:

=[Your Fiscal Year Dimension]& 'YTD'

Highlighted
Contributor III
Contributor III

It shows YTD for all the fiscal years.

Highlighted
Partner
Partner

Hi

use this in your dimension field

=[Fiscal Year]& ' YTD'

thanks

Highlighted
Contributor III
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

View solution in original post

Highlighted
Contributor III
Contributor III

FANTASTIC!!. Thanks a ton!

Highlighted
Partner
Partner

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