Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: Expression in Text Object

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
Highlighted
MVP
MVP

Re: Expression in Text Object

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

Highlighted
Creator III
Creator III

Re: Expression in Text Object

Try this

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

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