Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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 (5)
1 Solution

Accepted Solutions
jonathandienst
Partner
Partner

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
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'

ajinkyabhonsle
Contributor III
Contributor III
Author

It shows YTD for all the fiscal years.

kashyap
Partner
Partner

Hi

use this in your dimension field

=[Fiscal Year]& ' YTD'

thanks

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
Partner

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

ajinkyabhonsle
Contributor III
Contributor III
Author

FANTASTIC!!. Thanks a ton!

seematayade
Partner
Partner

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