Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajinkyabhonsle
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?

 

 

Labels (4)
1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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'

ajinkyabhonsle
Contributor III
Contributor III
Author

It shows YTD for all the fiscal years.

Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

use this in your dimension field

=[Fiscal Year]& ' YTD'

thanks

Thanks and Regards
Kashyap.R
ajinkyabhonsle
Contributor III
Contributor III
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

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
ajinkyabhonsle
Contributor III
Contributor III
Author

FANTASTIC!!. Thanks a ton!

seematayade
Partner - Contributor
Partner - Contributor

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