Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Expression in Text Object

Hi All,

I have two variables v_CurrentFiscalYear and  v_CurrentFiscalYearPeriod. Those two are returing correct value is I use these to show only value in Text Object. But I want to show like this:

Fiscal Year = CurrentFiscalYear and Fiscal Month = CurrentFiscalYearPeriod

My expression is like this:

='Fiscal Year =' & ='$(v_CurrentFiscalYear)'  & 'and Fiscal Month =' ='$(v_CurrentFiscalYearPeriod)'

But it is throwing error. How to to handle this.

Please help.

Thanks,

Sarif

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try removing the quotes around variable expansion and removing extra '=' signs, like:

='Fiscal Year =' & $(v_CurrentFiscalYear)  & 'and Fiscal Month =' & $(v_CurrentFiscalYearPeriod)

View solution in original post

2 Replies
tresesco
MVP
MVP

Try removing the quotes around variable expansion and removing extra '=' signs, like:

='Fiscal Year =' & $(v_CurrentFiscalYear)  & 'and Fiscal Month =' & $(v_CurrentFiscalYearPeriod)

dsharmaqv
Creator III
Creator III

Try this

='Fiscal Year = ' & '$(v_CurrentFiscalYear)'

='Fiscal Year = ' & '$(v_CurrentFiscalYearPeriod)'